pgsql-sql - December 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

Dec. 1, 2010

Thread	Author	Time
aggregation question	Samuel Gendler	03:47
OT - load a shp file	John Fabiani	06:06
Re: aggregation question	Samuel Gendler	09:06
Re: OT - load a shp file	Lee Hachadoorian	09:13
Re: DELETE WHERE EXISTS unexpected results	Carla	13:05
Re: OT - load a shp file	John Fabiani	14:29
Re: How strings are sorted by LC_COLLATE specifically?	Chang Chao	14:31
Re: DELETE WHERE EXISTS unexpected results	Jeff Bland	15:07

Dec. 2, 2010

Thread	Author	Time
Re: DELETE WHERE EXISTS unexpected results	Jasen Betts	07:47
COPY with FORMAT in Postgresql 9.x	Humair Mohammed	21:45
Calculate next event date based on instance of the day of week	Dimitri	21:46

Dec. 3, 2010

Thread	Author	Time
Re: Calculate next event date based on instance of the day of week	Jayadevan M	06:17
Get the max viewd product_id for user_id	Mario Splivalo	10:53
Re: Get the max viewd product_id for user_id	Jayadevan M	11:40
Re: COPY with FORMAT in Postgresql 9.x	Tom Lane	15:51
Union Question	Shaun McCloud	16:51
Re: Union Question	Plugge, Joe R.	16:58
Re: Union Question	Shaun McCloud	17:04
Re: Union Question	Christophe Pettus	17:08
Re: Union Question	Shaun McCloud	17:08
Re: Union Question	Christophe Pettus	17:27
Re: Union Question	Shaun McCloud	17:30
A note on how to generate a list of months within some period of time.	Michał Roszka	21:00
Re: Union Question	Jasen Betts	23:20

Dec. 5, 2010

Thread	Author	Time
Re: Get the max viewd product_id for user_id	Mario Splivalo	16:48
Re: Get the max viewd product_id for user_id	Mario Splivalo	16:57
Re: Get the max viewd product_id for user_id	Mario Splivalo	16:59

Dec. 6, 2010

Thread	Author	Time
Re: Get the max viewd product_id for user_id	Jayadevan M	02:55
First aggregate with null support	Marc Mamin	10:59
The best option to insert data with primary id	-	14:59
Re: The best option to insert data with primary id	mike	15:27
Re: The best option to insert data with primary id	mike	16:21
Re: Union Question	bricklen	19:39

Dec. 7, 2010

Thread	Author	Time
concatenate question	Tony Capobianco	21:07
concatenate question	Tony Capobianco	21:37
Re: concatenate question	Peter Steinheuser	21:43
Re: concatenate question	Tony Capobianco	21:47
Re: concatenate question	Dmitriy Igrishin	21:51
Re: concatenate question	Kenneth Marshall	21:52
Re: concatenate question	Richard Broersma	21:53
Re: concatenate question	Peter Steinheuser	21:54

Dec. 8, 2010

Thread	Author	Time
mybatis 3 RETURNING id problem with insert.	-	07:27
conditional aggregates	Marcin Krawczyk	12:49
Re: conditional aggregates	Pavel Stehule	13:07
Re: conditional aggregates	Marcin Krawczyk	13:19
Regular Expression Match Operator escape character	Gnanakumar	13:51
Re: conditional aggregates	Marc Mamin	14:06
Re: concatenate question	Tony Capobianco	14:08
Re: conditional aggregates	Marcin Krawczyk	14:35

Dec. 9, 2010

Thread	Author	Time
Re: concatenate question	Edgardo Portal	16:16
Extended query protocol and exact types matches.	Dmitriy Igrishin	18:24
Correct usage of FOR UPDATE?	Joe Carr	19:29
sqlplus reporting equivalent in postgres?	Tony Capobianco	21:47
Fwd: Extended query protocol and exact types matches.	Dmitriy Igrishin	22:10

Dec. 10, 2010

Thread	Author	Time
Fwd: Extended query protocol and exact types matches.	Dmitriy Igrishin	07:53
Re: Fwd: Extended query protocol and exact types matches.	Robert Haas	16:16
Re: Fwd: Extended query protocol and exact types matches.	Dmitriy Igrishin	16:46
Re: Extended query protocol and exact types matches.	Merlin Moncure	17:22
Re: Extended query protocol and exact types matches.	Dmitriy Igrishin	17:40
Re: Fwd: Extended query protocol and exact types matches.	Robert Haas	17:51
Re: Fwd: Extended query protocol and exact types matches.	Dmitriy Igrishin	17:58
Re: Extended query protocol and exact types matches.	Merlin Moncure	18:05
Re: Extended query protocol and exact types matches.	Dmitriy Igrishin	18:26

Dec. 11, 2010

Thread	Author	Time
Re: sqlplus reporting equivalent in postgres?	Igor Neyman	01:44
Re: sqlplus reporting equivalent in postgres?	Samuel Gendler	03:23
Re: sqlplus reporting equivalent in postgres?	Gary Chambers	03:28
Re: sqlplus reporting equivalent in postgres?	Samuel Gendler	03:44
Re: The best option to insert data with primary id	Jasen Betts	10:17
Re: Correct usage of FOR UPDATE?	Dmitriy Igrishin	10:32
Re: sqlplus reporting equivalent in postgres?	Thomas Kellerer	10:50
Re: concatenate question	Andreas Kretschmer	13:42

Dec. 13, 2010

Thread	Author	Time
Re: Regular Expression Match Operator escape character	Jasen Betts	09:18
constraint with check	Viktor Bojović	23:36

Dec. 14, 2010

Thread	Author	Time
Aggregating by unique values	Lee Hachadoorian	05:11
Re: constraint with check	Jasen Betts	07:12
Re: Using count on a join, group by required?	emaratiyya	07:19
Re: Aggregating by unique values	Filip Rembiałkowski	08:23
Re: Using count on a join, group by required?	Trinath Somanchi	08:53
Re: Using count on a join, group by required?	Rob Sargent	16:23
Re: Aggregating by unique values 📎	Lee Hachadoorian	17:24
Re: Using count on a join, group by required?	Rob Sargent	18:14

Dec. 15, 2010

Thread	Author	Time
How to convert string to integer	venkat	10:23
Re: How to convert string to integer	Szymon Guz	10:27
Re: [SQL] How to convert string to integer	Pavel Stehule	10:27
Re: [SQL] How to convert string to integer	Viktor Bojović	10:37
Database consistency after a power shortage	Alberto	15:12

Dec. 16, 2010

Thread	Author	Time
Translate Function PL/pgSQL to SQL92	serviciotdf	01:22
Re: Database consistency after a power shortage	Scott Marlowe	07:38
Re: Database consistency after a power shortage	Samuel Gendler	07:58
Re: Translate Function PL/pgSQL to SQL92	Filip Rembiałkowski	11:17
Re: Database consistency after a power shortage	Jean-David Beyer	14:38
UPDATE in a specific order	Luiz K. Matsumura	14:57
Re: UPDATE in a specific order	Jasen Betts	19:58
Create/update trigger auto-populate fields.	Chris Ruprecht	20:42

Dec. 17, 2010

Thread	Author	Time
Full Text search differences from 8.3 to 8.4.6	Achilleas Mantzios	10:19
Re: Translate Function PL/pgSQL to SQL92	serviciotdf	15:26
Help with Function in plpgsql	acurtis416	16:58
Re: UPDATE in a specific order	Luiz K. Matsumura	19:01

Dec. 18, 2010

Thread	Author	Time
Table name as a variable in SELECT query	Andrey Fokin	12:46
Re: Table name as a variable in SELECT query	Andreas Kretschmer	14:01

Dec. 21, 2010

Thread	Author	Time
linux. ossp-uuid	Николай Ижиков	08:31
Re: linux. ossp-uuid	Trinath Somanchi	11:06
converting type and function in postgresql ?	Amar Dhole	11:33
data import	Viktor Bojović	11:34
Re: data import	Pavel Stehule	11:36
Re: converting type and function in postgresql ?	Trinath Somanchi	11:58
Re: data import	Achilleas Mantzios	12:04
Re: data import	Chris Ruprecht	16:18

Dec. 22, 2010

Thread	Author	Time
Re: linux. ossp-uuid	Basil Bourque	02:00

Dec. 23, 2010

Thread	Author	Time
Issue while using PostgreSql 8.4.	Atul Kumar	08:31
Re: Issue while using PostgreSql 8.4.	Kevin Grittner	15:23

Dec. 29, 2010

Thread	Author	Time
Re: data import	Viktor Bojović	01:45

Dec. 30, 2010

Thread	Author	Time
create function problem	Gary Stainburn	16:26
Re: create function problem	Pavel Stehule	17:35
Re: create function problem	Adrian Klaver	17:47
Re: create function problem	Gary Stainburn	20:16
create role	Tony Capobianco	22:14
Re: create role	Adrian Klaver	22:23

Dec. 31, 2010

Thread	Author	Time
Re: create role	tcapobianco	16:22
Re: create role	Adrian Klaver	16:34
Re: create role	Adrian Klaver	17:05

Browse Archives

Prev | Next