pgsql-sql - May 2010

Discussion for users on SQL related matters.

Search the Archives

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

Advanced Search

Browse Archives

Prev | Next

May 1, 2010

Thread	Author	Time
Re: LIMIT problem	silly sad	08:55
Re: LIMIT problem	silly sad	09:05
Re: regexp_replace and search/replace values stored in table	Leif Biberg Kristensen	17:29

May 2, 2010

Thread	Author	Time
Re: regexp_replace and search/replace values stored in table	Sofer, Yuval	07:25

May 3, 2010

Thread	Author	Time
Prevent Domain Compare	Kaveh Mousavi Zamani	02:12
[GENERAL] Schema design / joins	E H	04:52
WAL-files restore and nextval('PK')	Andreas Gaab	11:16
Re: WAL-files restore and nextval('PK')	Tom Lane	13:33
Re: WAL-files restore and nextval('PK')	Alvaro Herrera	15:28

May 4, 2010

Thread	Author	Time
Re: [GENERAL] Schema design / joins	silly sad	12:05
Foreign key constraint referencing a parent table	David Weilers	13:49

May 5, 2010

Thread	Author	Time
help	Nicholas I	03:05
How to get localized to_char(DATE) output	Thomas Kellerer	22:26
Re: How to get localized to_char(DATE) output	Tom Lane	22:51

May 6, 2010

Thread	Author	Time
Re: How to get localized to_char(DATE) output	Thomas Kellerer	06:42
Re: How to get localized to_char(DATE) output	Jasen Betts	09:57
Re: How to get localized to_char(DATE) output	Thomas Kellerer	10:46
Re: How to get localized to_char(DATE) output	Tom Lane	14:22
Re: How to get localized to_char(DATE) output	Thomas Kellerer	14:37
Need a help in regexp	Nicholas I	14:48
Fwd: Need a help in regexp	Nicholas I	14:53
Re: Need a help in regexp	A. Kretschmer	15:04
Re: Need a help in regexp	Leif Biberg Kristensen	15:37
Column Specific Update Trigger Routine	Plugge, Joe R.	20:12
Re: Column Specific Update Trigger Routine	Plugge, Joe R.	20:51
Re: Column Specific Update Trigger Routine	Justin Graf	20:59
Re: Column Specific Update Trigger Routine	Plugge, Joe R.	21:02
Re: Column Specific Update Trigger Routine	Tom Lane	21:13

May 7, 2010

Thread	Author	Time
Re: help	Filip Rembiałkowski	15:24
Celko take on EAV	Richard Broersma	16:33
Re: Celko take on EAV	Justin Graf	18:43

May 10, 2010

Thread	Author	Time
[Trigger] Help needed with NEW.* and TG_TABLE_NAME	Torsten Zühlsdorff	09:35
Invalid message format Exception	Gnanakumar	14:19
advice on query joining 10 tables	Gerardo Herzig	18:40
Re: advice on query joining 10 tables	Tom Lane	20:11
Re: advice on query joining 10 tables	Scott Marlowe	20:37
Re: advice on query joining 10 tables	Gerardo Herzig	20:38
Re: advice on query joining 10 tables	Scott Marlowe	21:35

May 11, 2010

Thread	Author	Time
[Trigger] Help needed with NEW.* and TG_TABLE_NAME	Torsten Zühlsdorff	12:31
[Trigger] Help needed with NEW.* and TG_TABLE_NAME	Torsten Zühlsdorff	12:36
Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME	Tom Lane	14:23
Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME	Torsten Zühlsdorff	14:26
Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME	Stuart	22:06

May 12, 2010

Thread	Author	Time
best paging strategies for large datasets?	Louis-David Mitterrand	05:41
Re: best paging strategies for large datasets?	Pavel Stehule	05:45
Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME	silly sad	06:00
Invalid message format Exception	Gnanakumar	10:34
Re: Invalid message format Exception	Rob Sargent	14:51
Re: best paging strategies for large datasets?	Justin Graf	15:59
Re: best paging strategies for large datasets?	Justin Graf	16:26
Greetings folks, dumb question maybe?	Josh	17:32
Re: Greetings folks, dumb question maybe?	Josh	17:57
Re: Greetings folks, dumb question maybe?	Richard Broersma	21:04
Re: Greetings folks, dumb question maybe?	Little, Douglas	21:09

May 13, 2010

Thread	Author	Time
Re: Invalid message format Exception	Gnanakumar	07:04
Re: best paging strategies for large datasets?	silly sad	07:36
Re: best paging strategies for large datasets?	Louis-David Mitterrand	07:43
Re: best paging strategies for large datasets?	Louis-David Mitterrand	07:47
Re: best paging strategies for large datasets?	silly sad	08:41
Re: Greetings folks, dumb question maybe?	Jasen Betts	10:09
Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME	Jasen Betts	10:51
Re: Greetings folks, dumb question maybe?	Joshua Tolley	12:37
Re: best paging strategies for large datasets?	Justin Graf	13:28
Re: best paging strategies for large datasets?	Justin Graf	13:57
Re: Invalid message format Exception	Rob Sargent	15:18

May 14, 2010

Thread	Author	Time
Postgresql database	Trinath Somanchi	08:42
Re: Postgresql database	silly sad	09:14
Re: Postgresql database	Trinath Somanchi	09:28
Re: Postgresql database	Leif Biberg Kristensen	09:51
Re: Postgresql database	silly sad	10:23
Re: Postgresql database	Little, Douglas	13:20

May 16, 2010

Thread	Author	Time
import ignoring duplicates 📎	Mark Fenbers	18:38

May 17, 2010

Thread	Author	Time
Re: import ignoring duplicates	Tim Landscheidt	00:32
Re: import ignoring duplicates	Scott Marlowe	06:04
Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME	Torsten Zühlsdorff	08:57

May 18, 2010

Thread	Author	Time
How to get CURRENT_DATE in a pl/pgSQL function	Kenneth Marshall	19:08
Re: How to get CURRENT_DATE in a pl/pgSQL function	Richard Broersma	19:12
Re: How to get CURRENT_DATE in a pl/pgSQL function	Pavel Stehule	19:25
Re: How to get CURRENT_DATE in a pl/pgSQL function	Kenneth Marshall	19:27
Re: How to get CURRENT_DATE in a pl/pgSQL function	Kenneth Marshall	19:28
plperlu user function.	David Harel	21:29
Re: plperlu user function.	Alex Hunsaker	21:36
Re: How to get CURRENT_DATE in a pl/pgSQL function	Tim Landscheidt	22:20

May 19, 2010

Thread	Author	Time
Re: How to get CURRENT_DATE in a pl/pgSQL function	Brian Modra	03:48
Re: plperlu user function.	silly sad	05:38
Re: How to get CURRENT_DATE in a pl/pgSQL function	silly sad	08:26
Re: How to get CURRENT_DATE in a pl/pgSQL function	Tim Landscheidt	11:18
Re: How to get CURRENT_DATE in a pl/pgSQL function	Jasen Betts	11:25
Re: How to get CURRENT_DATE in a pl/pgSQL function	Kenneth Marshall	12:27
user function and bind	David Harel	14:56
Re: user function and bind 📎	Justin Graf	16:11
Re: user function and bind	Gary Chambers	17:16

May 21, 2010

Thread	Author	Time
[No subject]	tlange	00:52
sorry, now with subject... trigger & nextval(seq)	tlange	00:53
Re: sorry, now with subject... trigger & nextval(seq)	Adrian Klaver	01:46
Re:	Richard Broersma	01:56
[Fwd: Re: sorry, now with subject... trigger & nextval(seq)]	tlange	07:19
Re: sorry, now with subject... trigger & nextval(seq)	tlange	07:35
Re:	Craig Ringer	08:15
Re:	Richard Broersma	14:47
Access Update error: solution.	Little, Douglas	15:23
Question about slow queries...	Good, Thomas	15:44
Re: Access Update error: solution.	Torsten Lange	16:22

May 23, 2010

Thread	Author	Time
return %ROWTYPE from function	Anton Prokofiev	21:42

May 24, 2010

Thread	Author	Time
Re: return %ROWTYPE from function	jr	01:15
safely exchanging primary keys?	Louis-David Mitterrand	08:51
Re: safely exchanging primary keys?	jr	11:46
Re: safely exchanging primary keys?	Louis-David Mitterrand	14:05
Re: safely exchanging primary keys?	Tom Lane	14:22
Re: safely exchanging primary keys?	Rob Sargent	14:22
Re: safely exchanging primary keys?	Tim Landscheidt	14:38
Re: safely exchanging primary keys?	Louis-David Mitterrand	17:00
Re: safely exchanging primary keys?	Louis-David Mitterrand	17:11
User function that returns a set of rows.	David Harel	18:33
Re: User function that returns a set of rows.	Joshua Tolley	22:14

May 25, 2010

Thread	Author	Time
Re: safely exchanging primary keys?	Tim Landscheidt	01:22

May 26, 2010

Thread	Author	Time
inner join and limit	Michele Petrazzo - Unipex	17:34
Rules and sequences	Ben Morrow	18:16
Re: inner join and limit	Rolando Edwards	19:04
Re: inner join and limit	Luigi Antognini	20:13
Re: inner join and limit	Tim Landscheidt	21:03
Re: inner join and limit	Rolando Edwards	21:24
cast record type to array?	Gerardo Herzig	22:02

May 27, 2010

Thread	Author	Time
Re: Rules and sequences	Tom Lane	00:04
Re: Rules and sequences	A. Kretschmer	06:20
Do not understand "SETOF RECORD" - therefore can not use ODBC-link	Harrie Rodenbach	08:23
Check set of date intervals	Anton Gavazuk	10:07
Re: Check set of date intervals	A. Kretschmer	10:27
Re: Check set of date intervals	A. Kretschmer	10:43
Re: Check set of date intervals	A. Kretschmer	12:45
Fw: Re: help	James Kitambara	13:55
Re: Question about slow queries...	Tom Lane	14:03
Re: Do not understand "SETOF RECORD" - therefore can not use ODBC-link	Tom Lane	14:05
Re: Question about slow queries...	A. Kretschmer	14:09
Re: Rules and sequences	Ben Morrow	16:28
Extending Regular Expression bounds limit of 255.	Brent DeSpain	19:33
Re: Extending Regular Expression bounds limit of 255.	Andrej	20:59
Re: Extending Regular Expression bounds limit of 255.	Brent DeSpain	22:44
Re: Extending Regular Expression bounds limit of 255.	Brent DeSpain	22:55

May 28, 2010

Thread	Author	Time
Re: Do not understand "SETOF RECORD" - therefore can not use ODBC-link	Harrie Rodenbach	07:32
ODBC-link returns zero rows, allthough query should return 3 rows	Reinier Suurenbroek	08:07
Re: cast record type to array?	Jasen Betts	10:31
Re: Extending Regular Expression bounds limit of 255.	alvherre	15:14
Re: Extending Regular Expression bounds limit of 255.	Brent DeSpain	15:44
Re: cast record type to array?	Gerardo Herzig	20:14

May 29, 2010

Thread	Author	Time
Re: Extending Regular Expression bounds limit of 255.	Jasen Betts	10:27
Re: Extending Regular Expression bounds limit of 255.	Tim Landscheidt	18:56

May 30, 2010

Thread	Author	Time
Re: Extending Regular Expression bounds limit of 255.	Jasen Betts	10:37

Browse Archives

Prev | Next