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

Nov. 1, 2010

Thread	Author	Time
Sorting router interfaces	Brian Sherwood	12:15
Re: Sorting router interfaces	Filip Rembiałkowski	21:37

Nov. 2, 2010

Thread	Author	Time
Re: Sorting router interfaces	Andreas	00:23
problem with rules	Uwe Bartels	07:54

Nov. 4, 2010

Thread	Author	Time
I'm stuck - I just can't get this small FUNCT to run!	Ralph Smith	00:00
Re: I'm stuck - I just can't get this small FUNCT to run!	bricklen	00:09
Re: I'm stuck - I just can't get this small FUNCT to run!	Tom Lane	03:50
Trailing spaces - is there an easier way?	Dean Gibson (DB Administrator)	19:03
Re: Trailing spaces - is there an easier way?	Pavel Stehule	19:42
Re: Trailing spaces - is there an easier way?	Kenneth Marshall	19:47
Re: I'm stuck - I just can't get this small FUNCT to run!	Ralph Smith	20:07

Nov. 7, 2010

Thread	Author	Time
Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable	Will Furnass	10:18

Nov. 9, 2010

Thread	Author	Time
unexpected ORDER BY	Andreas	16:00
Re: unexpected ORDER BY	Tom Lane	16:10

Nov. 10, 2010

Thread	Author	Time
"slow lock" log in addition to log_min_duration_statement ?	Bryce Nesbitt	20:28

Nov. 11, 2010

Thread	Author	Time
Overlapping Ranges- Query Alternative	Ozer, Pam	19:07

Nov. 12, 2010

Thread	Author	Time
Re: Overlapping Ranges- Query Alternative	Andreas Gaab	08:23
Re: Overlapping Ranges- Query Alternative	Marc Mamin	08:57
Re: "slow lock" log in addition to log_min_duration_statement ?	Joshua Tolley	15:50
Re: Overlapping Ranges- Query Alternative	Ozer, Pam	16:36
psql -f COPY from STDIN	Tarlika Elisabeth Schmitz	22:03
Re: psql -f COPY from STDIN	Adrian Klaver	23:17

Nov. 13, 2010

Thread	Author	Time
Re: psql -f COPY from STDIN	Tom Lane	03:22
Re: psql -f COPY from STDIN	Tarlika Elisabeth Schmitz	12:01
Re: psql -f COPY from STDIN	Tom Lane	14:54
Re: psql -f COPY from STDIN	Tarlika Elisabeth Schmitz	15:04
Need help with plpgsql function.	berelith	23:48

Nov. 14, 2010

Thread	Author	Time
Re: Need help with plpgsql function.	Pavel Stehule	07:15
Re: Need help with plpgsql function.	Adrian Klaver	18:37
Re: Need help with plpgsql function.	Pavel Stehule	18:41

Nov. 16, 2010

Thread	Author	Time
multi table import from 1 denormalized source table	Andreas	05:57
Re: multi table import from 1 denormalized source table	Jasen Betts	08:21
Sum up network events by type, interval and network	Axel Rau	16:29

Nov. 17, 2010

Thread	Author	Time
PostgreSQL array, recursion and more 📎	Ferruccio Zamuner	13:22
Re: PostgreSQL array, recursion and more	Achilleas Mantzios	14:53
obtaining difference between minimum value and next in size	John Lister	15:11
Re: obtaining difference between minimum value and next in size	Tom Lane	15:42
Re: obtaining difference between minimum value and next in size	Andreas Kretschmer	16:02
Re: obtaining difference between minimum value and next in size	Oliveiros d'Azevedo Cristina	16:09
Re: obtaining difference between minimum value and next in size	John Lister	22:46

Nov. 18, 2010

Thread	Author	Time
Re: obtaining difference between minimum value and next in size	Oliveiros d'Azevedo Cristina	10:09

Nov. 19, 2010

Thread	Author	Time
force view column varchar(32) to varchar(128)	Emi Lu	15:02
Re: force view column varchar(32) to varchar(128)	Andreas Kretschmer	16:54
Re: force view column varchar(32) to varchar(128)	Richard Broersma	17:34

Nov. 21, 2010

Thread	Author	Time
Re: PostgreSQL array, recursion and more	Dmitriy Igrishin	11:50

Nov. 23, 2010

Thread	Author	Time
Howto "insert or update" ?	Andreas	03:44
Re: Howto "insert or update" ?	tv	04:11
"compressing" consecutive values into one	Louis-David Mitterrand	15:19
Re: "compressing" consecutive values into one	Oliveiros d'Azevedo Cristina	15:31
Re: "compressing" consecutive values into one	Louis-David Mitterrand	18:13
Re: "compressing" consecutive values into one	bricklen	18:19

Nov. 24, 2010

Thread	Author	Time
atomic multi-threaded upsert	Mikhail V. Puzanov	20:16
Re: "compressing" consecutive values into one	Louis-David Mitterrand	20:53
Re: atomic multi-threaded upsert	Tom Lane	21:21

Nov. 25, 2010

Thread	Author	Time
insert from a select	John Fabiani	00:07
Re: insert from a select	Adrian Klaver	00:25
Re: atomic multi-threaded upsert	KM	02:12
How strings are sorted by LC_COLLATE specifically?	Chang Chao	05:42
Re: atomic multi-threaded upsert	MIkhail Puzanov	06:51
Re: atomic multi-threaded upsert	MIkhail Puzanov	07:24
Re: insert from a select	Carla	11:40
Re: insert from a select	Carla	12:32
Re: insert from a select	John Fabiani	13:33
Re: insert from a select	Trinath Somanchi	15:22
error null value in column" concat_id" violates not-null constraint	Ana Louro	15:58

Nov. 26, 2010

Thread	Author	Time
Re: error null value in column" concat_id" violates not-null constraint	Pavel Stehule	07:45
group by hour + distinct	Michele Petrazzo - Unipex	11:39
Re: group by hour + distinct	Oliveiros d'Azevedo Cristina	12:19
Re: group by hour + distinct	Michele Petrazzo - Unipex	12:42
Re: group by hour + distinct	Oliveiros d'Azevedo Cristina	13:15
Re: group by hour + distinct	Lew	16:07
Insert row in 1.10.1 and 1.10.3	ndias	16:22
Re: Insert row in 1.10.1 and 1.10.3	Oliveiros d'Azevedo Cristina	16:52
Re: Insert row in 1.10.1 and 1.10.3	ndias	17:09
Re: Insert row in 1.10.1 and 1.10.3	Thomas Kellerer	17:14
Re: Insert row in 1.10.1 and 1.10.3	Guillaume Lelarge	17:25
Re: Insert row in 1.10.1 and 1.10.3	ndias	17:28

Nov. 27, 2010

Thread	Author	Time
Re: atomic multi-threaded upsert	Mikhail V. Puzanov	15:08

Nov. 28, 2010

Thread	Author	Time
Is there a solution for "SELECT OR INSERT"	Stefan Becker	23:30

Nov. 29, 2010

Thread	Author	Time
subselect and left join not working?	Jorge Arenas	05:38
Re: subselect and left join not working?	Jasen Betts	09:44
Re: subselect and left join not working?	Tom Lane	15:27

Nov. 30, 2010

Thread	Author	Time
Re: subselect and left join not working?	Jorge Arenas	04:29
Deleting entries from multiple tables	manidegr8	05:59
Re: Deleting entries from multiple tables	Dusan Misic	08:15
Re: Deleting entries from multiple tables	Dusan Misic	08:19
Re: Deleting entries from multiple tables	Achilleas Mantzios	08:36
Re: Deleting entries from multiple tables	manidegr8	10:00
Re: subselect and left join not working?	Carla	13:22
Re: Is there a solution for "SELECT OR INSERT"	Florian Weimer	14:16
indexing longish string	Rob Sargent	17:42
Re: indexing longish string	jose	17:50
Re: indexing longish string	Rob Sargent	17:57
Re: indexing longish string	Kenneth Marshall	18:36
Re: indexing longish string	Isaac Dover	19:21
Re: How strings are sorted by LC_COLLATE specifically?	Peter Eisentraut	19:31
Re: indexing longish string	Isaac Dover	20:03
DELETE WHERE EXISTS unexpected results	Jeff Bland	22:16

Browse Archives

Prev | Next