pgsql-sql - February 2005

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. 1, 2005

Thread Author Time
Re: plpgsql functions and NULLs Stephan Szabo 00:32
Re: plpgsql functions and NULLs Don Drake 02:12
BLOBs vs BYTEA Sam Adams 02:26
Re: plpgsql functions and NULLs Tom Lane 03:37
Re: BLOBs vs BYTEA Dennis Sacks 03:51
Re: error in function!! John DeSoi 04:42
Re: Iain 04:54
Re: Need SELECT rights to UPDATE/DELETE WHERE? Tom Lane 05:34
problem while converting sybase quries to postgres imam 07:14
Re: BLOBs vs BYTEA Achilleus Mantzios 08:04
Re: [SQL] OFFSET impact on Performance??? PFC 09:16
case sensitive/insensitive confusion Christoph Haller 09:50
Re: case sensitive/insensitive confusion Peter Eisentraut 10:14
Re: [SQL] OFFSET impact on Performance??? Sean Davis 11:38
Re: case sensitive/insensitive confusion Christoph Haller 11:44
Re: case sensitive/insensitive confusion Theodore Petrosky 12:48
Re: BLOBs vs BYTEA Karl Denninger 15:01
MSSQL versus Postgres timing Joel Fradkin 16:54
Re: MSSQL versus Postgres timing Scott Marlowe 16:59
Re: Dennis Sacks 17:00
Re: MSSQL versus Postgres timing Michael Fuhr 17:06
Re: MSSQL versus Postgres timing Bricklen Anderson 17:25
Re: case sensitive/insensitive confusion Tom Lane 18:36
Re: MSSQL versus Postgres timing Joel Fradkin 19:23
Re: MSSQL versus Postgres timing 📎 Joel Fradkin 19:26
Re: MSSQL versus Postgres timing Joel Fradkin 20:19
Re: MSSQL versus Postgres timing 📎 Joel Fradkin 20:19
Re: MSSQL versus Postgres timing PFC 21:47
Re: MSSQL versus Postgres timing Tom Lane 21:53
Re: MSSQL versus Postgres timing Joel Fradkin 22:09

Feb. 2, 2005

Thread Author Time
Re: Calendar Function Muhyiddin A.M Hayat 02:53
Re: Calendar Function Bradley Miller 03:03
Re: Calendar Function Michael Fuhr 03:45
plpgsql functions to 'C' functions Peter Manchev 13:57
pgdump by schema? Bradley Miller 15:33
Re: pgdump by schema? Adam Witney 15:46
Re: pgdump by schema? Kretschmer Andreas 15:46
Re: pgdump by schema? Michael Fuhr 15:54
Re: pgdump by schema? Bradley Miller 15:58
locale with os x Theodore Petrosky 16:02
pg_restore problem Bradley Miller 20:17
Re: pg_restore problem Joel Fradkin 20:46
PL/PgSQL - returning multiple columns ... Marc G. Fournier 21:10
Re: pg_restore problem Tom Lane 21:24
Re: PL/PgSQL - returning multiple columns ... George Weaver 22:45

Feb. 3, 2005

Thread Author Time
problem with postgres Luiz Rafael Culik Guimaraes 01:33
problem with postgres Luiz Rafael Culik Guimaraes 01:43
Re: plpgsql functions to 'C' functions Michael Fuhr 06:21
Re: problem with postgres Michael Fuhr 06:49
Re: problem while converting sybase quries to postgres Richard Huxton 09:33
Tunning postgresql on linux (fedora core 3) Din Adrian 09:55
Re: problem while converting sybase quries to postgres Richard Huxton 10:52
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 10:54
pg primary key bug? pginfo 12:53
Re: plpgsql functions to 'C' functions Peter Manchev 13:31
Re: pg primary key bug? pginfo 13:52
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 13:56
Re: pg primary key bug? Michael Glaesemann 14:14
Re: pg_restore problem Bradley Miller 14:16
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 14:52
Re: [PERFORM] Tunning postgresql on linux (fedora core 3) Richard Huxton 15:15
Re: pg_restore problem Richard Huxton 15:25
problem with backup and restore (probaly stupit newb thing) Joel Fradkin 16:14
Re: pg primary key bug? Richard_D_Levine 16:30
Re: PL/PgSQL - returning multiple columns ... Marc G. Fournier 16:48
Re: [PERFORM] Tunning postgresql on linux (fedora core 3) Din Adrian 16:59
Re: problem with backup and restore (probaly stupit newb thing) Richard Huxton 17:38
Re: PL/PgSQL - returning multiple columns ... PFC 18:15
Re: problem with backup and restore (probaly stupit newb thing) Tom Lane 18:16
Re: plpgsql functions to 'C' functions Michael Fuhr 19:00
Re: pg_restore problem Bradley Miller 19:04
Re: Information about the command SQL " create synonym". Philip Patterson 19:48
Re: Calendar Function Jeff Boes 19:56
Re: problem with backup and restore (probaly stupit newb thing) Joel Fradkin 19:58
Re: Information about the command SQL " create synonym". Karsten Hilbert 20:04
pg_restore problem -- MORE?!? Bradley Miller 22:00
getting back autonumber just inserted lorid 22:16
Re: getting back autonumber just inserted Scott Marlowe 22:16
Re: getting back autonumber just inserted Sean Davis 22:19
Re: getting back autonumber just inserted Edmund Bacon 22:53

Feb. 4, 2005

Thread Author Time
Determining Rank Don Drake 03:06
Re: Determining Rank Michael Fuhr 04:21
Re: Determining Rank Michael Glaesemann 05:02
Accessing objects over db-borders KÖPFERL Robert 11:00
Re: [despammed] Accessing objects over db-borders Andreas Kretschmer 11:34
Re: getting back autonumber just inserted Richard_D_Levine 14:11
the best way to get the first record from each group q2005 14:13
Re: getting back autonumber just inserted Magnus Hagander 14:48
Re: Determining Rank Don Drake 21:18
Re: Determining Rank PFC 21:36

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

Browse Archives

Prev | Next