pgsql-sql since 2005-02-05 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Feb. 5, 2005

Thread Author Time
Assoclist is still slow and I am not seeing it Joel Fradkin 21:38
postgres8 install on fedora core 3 (or redhat4 beta AS) Joel Fradkin 22:36

Feb. 6, 2005

Thread Author Time
specifying different location for data and wal on fedora core 3 /backup question again Joel Fradkin 00:24

Feb. 7, 2005

Thread Author Time
How can I use large object on PostgreSQL Linux Version? Premsun Choltanwanich 04:40
Re: postgres8 install on fedora core 3 (or redhat4 beta AS KÖPFERL Robert 08:49
Re: How can I use large object on PostgreSQL Linux Version? KÖPFERL Robert 09:05
Re: Rule problem with OLD / NEW record set Christoph Haller 10:23
Red hat 3 AS when uptodate is it running 2.6 Kernel? Joel Fradkin 15:15
[No subject] Joel Fradkin 19:26

Feb. 8, 2005

Thread Author Time
the best way to get the first record from each group q2005 00:36
Re: the best way to get the first record from each group Michael Fuhr 01:16
Re: How can I use large object on PostgreSQL Linux Premsun Choltanwanich 01:32
Re: the best way to get the first record from each group PFC 02:20
Re: the best way to get the first record from each group Michael Fuhr 03:31
Updating selected record Levente Lajko 14:05
Did a good restore Joel Fradkin 15:39

Feb. 9, 2005

Thread Author Time
8 rpms for red hat Joel Fradkin 01:04
Can tsearch replace ilike queries ? Antony Paul 05:21
Maximum length of a query Antony Paul 06:13
Re: Updating selected record John DeSoi 06:42
How to know a temp table exists ? Antony Paul 06:45
Re: Maximum length of a query Michael Fuhr 07:31
copy rows drdani 07:53
parsing a string with a hexadecimal notation KÖPFERL Robert 11:01
Re: parsing a string with a hexadecimal notation Achilleus Mantzios 13:35
How to iterate through arrays? NosyMan 13:59
Re: How to iterate through arrays? PFC 14:16
Re: How to iterate through arrays? NosyMan 14:26
Re: How to iterate through arrays? John DeSoi 15:06
Re: parsing a string with a hexadecimal notation Tom Lane 20:51
Function .. AS..? Ing. Jhon Carrillo 20:57

Feb. 10, 2005

Thread Author Time
Re: Function .. AS..? Stephan Szabo 06:06
Re: [SQL] Function .. AS..? Michael Fuhr 06:16
Re: parsing a string with a hexadecimal notation KÖPFERL Robert 09:37
postgres 8 data directory other then default? Joel Fradkin 19:47
postgres 8 data directory other then default? Joel Fradkin 19:48
append fields for *where...* Johnny C 22:45
Re: append fields for *where...* Bruno Wolff III 23:12

Feb. 11, 2005

Thread Author Time
Re: append fields for *where...* Guillaume LELARGE 08:24
Re: postgres 8 data directory other then default? Richard Huxton 09:22
Matching a column against values in code Tim 16:12
Constraint doesn't see a currently insertet record KÖPFERL Robert 18:10
Re: postgres 8 data directory other then default? Joel Fradkin 19:02
GROUPing only those rows that do not contain a NULL field? Simon Kinsella 20:44

Feb. 13, 2005

Thread Author Time
Re: Constraint doesn't see a currently insertet record Michael Fuhr 01:57
Order of columns in a table important in a stored procedure? Marc SCHAEFER 17:03
Re: Order of columns in a table important in a stored procedure? Tom Lane 17:49
Re: Order of columns in a table important in a stored procedure? Richard Gintz 22:43
XML Theo Galanakis 23:53

Feb. 14, 2005

Thread Author Time
Working with XML. Theo Galanakis 05:48
Re: Working with XML. George Weaver 13:38
Re: copy rows Christoph Haller 14:04
triggers AL ELK 15:42
Re: triggers Michael Fuhr 18:27
Re: triggers PFC 20:06
how to select custom value when exists otherwise select default patrick 23:26

Feb. 15, 2005

Thread Author Time
Re: Working with XML. Theo Galanakis 03:46
How to view the list of tables ? Konstantin Danilov 10:16
Re: How to view the list of tables? Dick Davies 10:37
Re: How to view the list of tables? Richard Huxton 10:47
Re: How to view the list of tables? Dick Davies 10:49
Re: How to view the list of tables? Shridhar Daithankar 11:04
Re: How to view the list of tables? Mihail Nasedkin 11:15
Re: Constraint doesn't see a currently insertet record KÖPFERL Robert 12:40
Re: Working with XML. George Weaver 13:36

Feb. 16, 2005

Thread Author Time
Making NULL entries appear first when ORDER BY <field> ASC Andreas Joseph Krogh 00:55
Re: Working with XML. George Weaver 01:32
Re: Making NULL entries appear first when ORDER BY <field> ASC Rosser Schwarz 02:24
Re: Making NULL entries appear first when ORDER BY <field> Ragnar Hafstað 02:31
Re: Making NULL entries appear first when ORDER BY <field> ASC Greg Sabino Mullane 04:08
Re: Making NULL entries appear first when ORDER BY <field> ASC Bruno Wolff III 04:47
Re: Making NULL entries appear first when ORDER BY <field> ASC Andreas Joseph Krogh 09:39
Trigger Eugen Gass 13:44
More efficient OR Keith Worthington 16:02
Re: More efficient OR Reinoud van Leeuwen 16:15
Re: More efficient OR Scott Marlowe 16:15
Re: More efficient OR Sean Davis 16:21
Re: More efficient OR Keith Worthington 16:35
Relation in tables lucas 16:43
Count Columns Ray Madigan 18:09
Re: Relation in tables KÖPFERL Robert 18:33
Re: More efficient OR KÖPFERL Robert 18:36
Re: More efficient OR PFC 18:52
Re: Relation in tables PFC 18:56
Re: Count Columns Bruno Wolff III 19:58
Re: Matching a column against values in code PFC 20:01
Comments on subquery performance T- Bone 20:16
UPDATE TRIGGER on view WAS: Re: Relation in tables Keith Worthington 20:48
Re: Order of columns in a table important in a stored procedure? Geoffrey 20:51
Re: Trigger Pavel Rabel 20:53
Re: UPDATE TRIGGER on view WAS: Re: Relation in tables PFC 21:22
Re: Order of columns in a table important in a stored procedure? PFC 21:27
Re: UPDATE TRIGGER on view WAS: Re: Relation in tables Tom Lane 21:39
Re: Trigger Michael Fuhr 23:47

Feb. 17, 2005

Thread Author Time
[No subject] dawnsky 00:45
Re: [SQL] Trigger Eugen Gass 09:29
diff value retuns, debug mode and play mode AL ELK 10:18
Re: Relation in tables lucas 10:57
Re: pg primary key bug? pginfo 15:12
VIEW / ORDER BY + UNION WeiShang 15:46
No triggers visible for different user in information_schema.triggers Oliver Brück 15:58
Re: pg primary key bug? pginfo 16:01
Re: pg primary key bug? Michael Fuhr 16:40
Re: pg primary key bug? pginfo 16:41
LOOP? Ray Madigan 16:59
Re: pg primary key bug? Tom Lane 17:26
Re: pg primary key bug? pginfo 17:34
Re: No triggers visible for different user in information_schema.triggers Michael Fuhr 17:43
Comments on subquery performance T- Bone 17:55
Re: LOOP? Richard Huxton 18:05
Re: pg primary key bug? Tom Lane 18:19
Re: pg primary key bug? Tom Lane 19:01
Re: Comments on subquery performance Richard Huxton 19:15

Feb. 18, 2005

Thread Author Time
Re: pg primary key bug? pginfo 04:53
Re: pg primary key bug? pginfo 06:18
Re: pg primary key bug? Iain 06:34
Re: VIEW / ORDER BY + UNION CoL 08:26
Re: No triggers visible for different user in information_schema.triggers Peter Eisentraut 11:00
trrouble inserting stuff like é Joel Fradkin 14:59
Re: trrouble inserting stuff like é Aarni Ruuhimäki 15:25
RE: [SQL] trrouble inserting stuff like é Joel Fradkin 16:15
Re: Comments on subquery performance T- Bone 18:24
Re: Comments on subquery performance Joel Fradkin 18:44
RE: [SQL] trrouble inserting stuff like é Joel Fradkin 20:37
Re: RE: [SQL] trrouble inserting stuff like é John DeSoi 20:42
RE: [SQL] RE: [SQL] trrouble inserting stuff like é Joel Fradkin 21:03

Feb. 19, 2005

Thread Author Time
what does ONLY do Bret Hughes 01:59
Re: what does ONLY do Stephan Szabo 03:15
Re: what does ONLY do Bret Hughes 04:08
Re: trrouble inserting stuff like é Aarni Ruuhimäki 08:21

Feb. 21, 2005

Thread Author Time
FW: Working with XML. Theo Galanakis 00:52
FW: Working with XML. Theo Galanakis 05:28
Re: pg primary key bug? pginfo 07:51
Timestamp with timezone question. Achilleus Mantzios 14:16
Re: Working with XML. 📎 George Weaver 14:55
Re: Timestamp with timezone question. Andrew - Supernews 15:36
Re: Timestamp with timezone question. Achilleus Mantzios 16:44
query for records based on date Brandon Metcalf 20:00
Re: FW: Working with XML. Mirko Zeibig 20:36
Re: query for records based on date Martín Marqués 20:42
Re: query for records based on date Brandon Metcalf 20:48
Re: query for records based on date Richard Huxton 20:53
Re: pg primary key bug? Tom Lane 22:51

Feb. 22, 2005

Thread Author Time
Re: pg primary key bug? pginfo 05:25
Re: Timestamp with timezone question. Bruno Wolff III 06:59
Re: Timestamp with timezone question. Achilleus Mantzios 08:24
Re: pg primary key bug? Tom Lane 08:42
Re: pg primary key bug? pginfo 09:33
Re: pg primary key bug? pginfo 11:49
Re: pg primary key bug? Ragnar Hafstað 11:52
problem inserting local characters ... Garry 13:01
Re: pg primary key bug? Markus Schaber 13:36
Re: problem inserting local characters ... Markus Schaber 13:40
Re: Working with XML. George Weaver 13:45
Re: problem inserting local characters ... Joel Fradkin 14:34
Re: pg primary key bug? Tom Lane 16:37
Re: pg primary key bug? pginfo 16:42
Re: pg primary key bug? pginfo 17:20
Re: pg primary key bug? Tom Lane 18:04
schemas and paths with the alter statement Theodore Petrosky 19:06
Re: schemas and paths with the alter statement Tom Lane 19:16
Re: schemas and paths with the alter statement Richard Huxton 19:17
Re: schemas and paths with the alter statement Ragnar Hafstað 19:26
Re: schemas and paths with the alter statement Theodore Petrosky 19:32
aggregate / group by question T E Schmitz 20:14
how can I query for unset timestamps Bret Hughes 21:09
Re: how can I query for unset timestamps Gregory S. Williamson 21:19
Re: how can I query for unset timestamps Bret Hughes 22:05
Re: Working with XML. Theo Galanakis 22:13
Speeds using a transaction vrs not Joel Fradkin 22:19
Pagination with Output Variables? Steve - DND 23:29

Feb. 23, 2005

Thread Author Time
Re: Pagination with Output Variables? Michael Fuhr 00:26
Re: Speeds using a transaction vrs not Richard Huxton 08:02
Re: No triggers visible for different user in information_schema.triggers Oliver Brück 08:05
Re: No triggers visible for different user in information_schema.triggers Michael Fuhr 08:55
Postgres 8 - problem: invalid input syntax for integer mauro 10:19
Postgres performance mauro 10:29
Advanced SELECT Kai Hessing 13:43
Software for database-visualisation Kai Hessing 13:56
PostgreSQL ignores my indexes Thomas Braad Toft 14:01
Re: PostgreSQL ignores my indexes Andrew Sullivan 14:25
dblink versus schemas. What to use in this case? KÖPFERL Robert 14:33
Re: Working with XML. George Weaver 14:59
Re: Comments on subquery performance Edmund Bacon 16:05
Row Count sreejith s 16:18
Re: Row Count Michael Fuhr 16:51
Re: VIEW / ORDER BY + UNION Bruno Wolff III 17:19
Re: VIEW / ORDER BY + UNION KÖPFERL Robert 18:33
Re: VIEW / ORDER BY + UNION Bruno Wolff III 19:44
Re: Making NULL entries appear first when ORDER BY <field> ASC Thomas F.O'Connell 19:54
Re: Making NULL entries appear first when ORDER BY <field> Ken Johanson 20:12
Re: Making NULL entries appear first when ORDER BY <field> ASC Thomas F.O'Connell 20:22
Re: Making NULL entries appear first when ORDER BY <field> ASC Bruno Wolff III 20:33
Re: dblink versus schemas. What to use in this case? Gregory S. Williamson 21:10
Re: Working with XML. Theo Galanakis 22:42

Feb. 24, 2005

Thread Author Time
Re: aggregate / group by question Keith Worthington 03:56
Junk queries with variables? Steve - DND 06:12
Re: Junk queries with variables? Michael Fuhr 07:40
Re: Postgres performance Richard Huxton 08:05
Re: Postgres 8 - problem: invalid input syntax for integer Richard Huxton 08:14

Browse Archives

Prev | Next