pgsql-sql since 2011-09-09 00:00

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

Sept. 9, 2011

Thread	Author	Time
My Trigger is not working :(	Waqar Azeem	12:27
Re: how can I get the length of columns of a table by system tables/views	shuaixf	12:53
Re: My Trigger is not working :(	pasman pasmański	13:23
Re: My Trigger is not working :(	Waqar Azeem	13:31

Sept. 10, 2011

Thread	Author	Time
Re: Re: how can I get the length of columns of a table by system tables/views	msi77	05:51
Dynamic sql	Gabriel Filipiak	06:45
Re: Dynamic sql	Jasen Betts	09:18
FW: Hi	Mandana Mokhtary	21:22
FW: Hi	Mandana Mokhtary	21:22
Re: FW: Hi	Adrian Klaver	22:04

Sept. 12, 2011

Thread	Author	Time
Re: FW: Hi	Craig Ringer	01:31
Use select and update together	Boris	10:36

Sept. 13, 2011

Thread	Author	Time
Re: Use select and update together	pasman pasmański	05:50
Re: Use select and update together	Samuel Gendler	06:45
Partition over a sliding date window	Guillaume Roger	11:25
Window function sort order help	Dianna Harter	18:04
Re: Window function sort order help	nicoletta maia	20:53

Sept. 14, 2011

Thread	Author	Time
Re: Window function sort order help	Nicoletta Maia	08:30
Re: Window function sort order help	Thomas Kellerer	09:02
Re: Window function sort order help	Dianna Harter	16:54
Re: Window function sort order help	Nicoletta Maia	17:24

Sept. 15, 2011

Thread	Author	Time
Clever way to check overlapping time intervals ?	Andreas	23:40

Sept. 16, 2011

Thread	Author	Time
Re: Clever way to check overlapping time intervals ?	Andreas Kretschmer	00:15
Re: Clever way to check overlapping time intervals ?	pasman pasmański	09:17
Re: Clever way to check overlapping time intervals ?	Frank Bax	11:15
Re: Window function sort order help	Tim Landscheidt	23:55

Sept. 17, 2011

Thread	Author	Time
Passing function parameters to regexp_replace	Leif Biberg Kristensen	11:21
Re: Passing function parameters to regexp_replace	Leif Biberg Kristensen	11:31
Sorting of data from two tables	R. Smith	13:32
Re: Sorting of data from two tables	David Johnston	13:56
insert or update within transaction	Andreas	14:52
Re: Use select and update together	Andreas	14:56
Re: insert or update within transaction	Josh Kupershmidt	15:49
Re: Use select and update together	Guillaume Lelarge	15:51
Re: Use select and update together	Tom Lane	16:16
Re: Passing function parameters to regexp_replace	Tim Landscheidt	17:07
Re: Passing function parameters to regexp_replace	Leif Biberg Kristensen	17:27
select xpath ...	boris	17:48
Re: Passing function parameters to regexp_replace	Tim Landscheidt	18:34

Sept. 19, 2011

Thread	Author	Time
Re: select xpath ...	Rob Sargent	14:49
Re: select xpath ...	boris	15:49
Re: Window function sort order help	Dianna Harter	21:31

Sept. 20, 2011

Thread	Author	Time
Combining several CTEs with a recursive CTE	Thomas Kellerer	09:58
Re: Combining several CTEs with a recursive CTE	David Johnston	14:15
Re: Combining several CTEs with a recursive CTE	Thomas Kellerer	14:54

Sept. 21, 2011

Thread	Author	Time
handling duplicate row exception	Amar Dhole	05:54
Re: handling duplicate row exception	Filip Rembiałkowski	15:07
Re: Trigger Procedure Error: NEW used in query that is not in a rule	jablonov	15:32
Re: select xpath ...	Brian Sherwood	16:27
ambiguous local variable name in 9.0 proc	Samuel Gendler	23:35
Re: ambiguous local variable name in 9.0 proc	David Johnston	23:49
Re: ambiguous local variable name in 9.0 proc	Samuel Gendler	23:55

Sept. 22, 2011

Thread	Author	Time
Re: ambiguous local variable name in 9.0 proc	Tom Lane	00:00
a spatial table's bounding box	Asli Akarsakarya	06:04
Re: handling duplicate row exception	Amar Dhole	06:11
help with xpath namespace	Brian Sherwood	15:03

Sept. 23, 2011

Thread	Author	Time
using the aggregate function max()	John Fabiani	02:49
Re: using the aggregate function max()	David Johnston	03:14
Re: using the aggregate function max()	John Fabiani	04:40
use of savepoint in containter managed transaction	Amar Dhole	06:32
Re: using the aggregate function max()	Thomas Kellerer	06:37
Re: help with xpath namespace	Filip Rembiałkowski	16:14
Re: a spatial table's bounding box	Filip Rembiałkowski	19:18

Sept. 24, 2011

Thread	Author	Time
Howto build a funtion that selects an id or inserts a value	Andreas	00:06
Better way to check more than 1 value NOT IN (...)	Andreas	09:38
Re: Better way to check more than 1 value NOT IN (...)	pasman pasmański	11:54

Sept. 25, 2011

Thread	Author	Time
Re: Sorting of data from two tables	R. Smith	16:37
Re: Sorting of data from two tables	David Johnston	18:44

Sept. 26, 2011

Thread	Author	Time
Re: help with xpath namespace	Brian Sherwood	13:56

Sept. 27, 2011

Thread	Author	Time
Re: handling duplicate row exception	Filip Rembiałkowski	00:57
how to calculate differences of timestamps?	Andreas	01:31
Re: how to calculate differences of timestamps?	Tim Landscheidt	02:42
Re: how to calculate differences of timestamps?	Steve Crawford	16:08

Sept. 29, 2011

Thread	Author	Time
Edit multiple rows concurrent save	Péter Szabó	21:58
Edit multiple rows concurrent save	Péter Szabó	22:07

Oct. 4, 2011

Thread	Author	Time
Re: a spatial table's bounding box	Asli Akarsakarya	18:22

Oct. 6, 2011

Thread	Author	Time
plpgsql function executed multiple times for each return value	Steve Northamer	17:59

Oct. 8, 2011

Thread	Author	Time
Re: Edit multiple rows concurrent save	Jasen Betts	09:19
Re: plpgsql function executed multiple times for each return value	David Johnston	15:50
Re: plpgsql function executed multiple times for each return value	Tom Lane	16:32

Oct. 9, 2011

Thread	Author	Time
[GENERAL] Creating rule for sliding data	F. BROUARD / SQLpro	10:22
Re: [GENERAL] Creating rule for sliding data	F. BROUARD / SQLpro	16:50
Re: [GENERAL] Creating rule for sliding data	Guillaume Lelarge	17:07
Re: [GENERAL] Creating rule for sliding data	Guillaume Lelarge	20:25

Oct. 10, 2011

Thread	Author	Time
Re:	HAKAN	18:31

Oct. 11, 2011

Thread	Author	Time
Re: Extract week from date, start with sunday	skdangi	16:19

Oct. 12, 2011

Thread	Author	Time
[No subject]	HAKAN	00:15
[No subject]	Theodore Petrosky	05:37

Oct. 14, 2011

Thread	Author	Time
Re: 6	HAKAN	12:32
postgres sql help	James Bond	15:41
Tripping over (my own) stupidity - VARCHAR declaration minus specificity	Good, Thomas	17:27
Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity	Adam Cornett	17:51
Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity	[email protected]	18:09
Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity	Adam Cornett	18:24
Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity	Good, Thomas	18:28

Oct. 15, 2011

Thread	Author	Time
Group by on Date	maya.more	06:51

Oct. 16, 2011

Thread	Author	Time
Re: postgres sql help	Andreas Kretschmer	08:11
Re: postgres sql help	Harald Fuchs	08:24
Re: Group by on Date	Andreas Kretschmer	08:27
Re: Group by on Date	Harald Fuchs	08:35

Oct. 17, 2011

Thread	Author	Time
Re: postgres sql help	Tim Landscheidt	20:44

Oct. 18, 2011

Thread	Author	Time
new user on mac	Scott Swank	21:47

Oct. 19, 2011

Thread	Author	Time
Re: new user on mac	Adam Cornett	02:08
Re: new user on mac	Vibhor Kumar	02:43
Re: new user on mac	Basil Bourque	08:13
Problem with DROP ROLE	Brice André	10:11
Re: Problem with DROP ROLE	Andreas Kretschmer	11:32
Re: Problem with DROP ROLE	Guillaume Lelarge	11:59
Re: Problem with DROP ROLE	Brice André	12:19
How to write sql to access another odbc source.	Rich	14:08
How to write query to access another odbc source	Rich	15:19
Re: How to write query to access another odbc source	Scott Marlowe	15:47
Re: How to write query to access another odbc source	pasman pasmański	17:53
Re: How to write query to access another odbc source	Rich	19:23

Oct. 20, 2011

Thread	Author	Time
Re: new user on mac	Scott Swank	02:57
Re: new user on mac	Guillaume Lelarge	10:22
Re: new user on mac	Scott Swank	11:15
Re: new user on mac	Samuel Gendler	11:51
Re: new user on mac	Thomas Kellerer	12:14

Oct. 21, 2011

Thread	Author	Time
how to temporally disable foreign key constraint check	Emi Lu	13:36
Re: how to temporally disable foreign key constraint check	Oliveiros d'Azevedo Cristina	14:58
Question about Escaping text when calling pgplsql functions	Matthias Howell	15:38
Re: how to temporally disable foreign key constraint check	Emi Lu	15:47
Re: how to temporally disable foreign key constraint check	Thomas Kellerer	17:04
Re: how to temporally disable foreign key constraint check	Craig Ringer	23:51

Oct. 22, 2011

Thread	Author	Time
advice on how to store variable attributes	Linos	10:41
Re: advice on how to store variable attributes	David Johnston	12:53
Re: advice on how to store variable attributes	Pavel Stehule	14:07
Re: advice on how to store variable attributes	David Johnston	14:28
Re: advice on how to store variable attributes	Pavel Stehule	14:33
Re: advice on how to store variable attributes	Linos	15:39
Re: advice on how to store variable attributes	Pavel Stehule	16:05
Re: advice on how to store variable attributes	Scott Swank	16:06
Re: advice on how to store variable attributes	David Johnston	16:10
Re: advice on how to store variable attributes	Linos	17:14

Oct. 23, 2011

Thread	Author	Time
To having or not to having? 📎	Ferruccio Zamuner	21:12
Re: To having or not to having?	Ferruccio Zamuner	22:55

Oct. 24, 2011

Thread	Author	Time
RPostgreSQL Win32 package	Jira, Marcel	07:15
Re: RPostgreSQL Win32 package	tuan	16:51
Handling mutliple clients access with views	Brice André	19:23
Re: new user on mac	Guillaume Lelarge	21:24

Oct. 25, 2011

Thread	Author	Time
CTE or Subselect and outer joins not behaving as expected?	Joel Stevenson	00:46
Re: CTE or Subselect and outer joins not behaving as expected?	bricklen	01:46
Re: Handling mutliple clients access with views	Craig Ringer	02:54
Re: Handling mutliple clients access with views	David Johnston	03:36
Re: Handling mutliple clients access with views	Craig Ringer	03:50
Re: Handling mutliple clients access with views	bricklen	03:52
Re: Handling mutliple clients access with views	Brice André	06:02
Re: How to write sql to access another odbc source.	Craig Ringer	07:59
Re: CTE or Subselect and outer joins not behaving as expected?	Harald Fuchs	12:42
how to use explain analyze	alan	14:12
optimize self-join query	Ty Busby	18:37

Oct. 26, 2011

Thread	Author	Time
Re: CTE or Subselect and outer joins not behaving as expected?	Joel Stevenson	17:22

Oct. 27, 2011

Thread	Author	Time
How to obtain a coalesce aggregation in a GROUP BY query?	Federico Dal Maso	10:28
Re: how to use explain analyze	Brent Dombrowski	17:06

Oct. 28, 2011

Thread	Author	Time
Re: optimize self-join query	Tom Lane	00:26
Different order by behaviour depending on where clause?	Jan Bakuwel	04:53
Re: optimize self-join query	Lee Hachadoorian	05:12
Re: Different order by behaviour depending on where clause?	Pavel Stehule	05:13
Re: optimize self-join query	Harald Fuchs	09:31
Re: Different order by behaviour depending on where clause?	Phil Couling	10:25

Oct. 29, 2011

Thread	Author	Time
Re: optimize self-join query	Ty Busby	21:04
Re: Different order by behaviour depending on where clause?	Jan Bakuwel	21:16

Nov. 1, 2011

Thread	Author	Time
Re: select xpath ...	Ross J. Reedstrom	16:17

Nov. 2, 2011

Thread	Author	Time
\COPY in psql using \e	Ivan Sergio Borgonovo	10:16
Number timestamped rows	Jan Peters	16:36
Re: Number timestamped rows	Andreas Kretschmer	16:51

Nov. 3, 2011

Thread	Author	Time
intervals	Edward W. Rouse	17:29
Re: intervals	Jonathan S. Katz	17:41
Re: intervals	bricklen	17:43
Re: intervals	Edward W. Rouse	17:56
Re: intervals	Edward W. Rouse	17:59
Re: intervals	Michael Glaesemann	18:20

Nov. 4, 2011

Thread	Author	Time
Create Type with typmod_in	Russell Keane	14:01
Re: Create Type with typmod_in	David Johnston	14:33
the use of $$string$$	John Fabiani	14:38
Re: the use of $$string$$	bricklen	14:57
Re: the use of $$string$$	Tom Lane	14:57
Re: the use of $$string$$	John Fabiani	15:26
Re: the use of $$string$$	David Johnston	16:05
Re: the use of $$string$$	John Fabiani	16:33
Re: the use of $$string$$	Richard Huxton	18:06
How to implement Aggregate Awareness?	Olgierd Michalak	20:09
How to implement Aggregate Awareness?	Olgierd Michalak	21:03

Nov. 5, 2011

Thread	Author	Time
Re: the use of $$string$$	John Fabiani	00:12
Re: How to implement Aggregate Awareness?	Craig Ringer	03:35

Nov. 6, 2011

Thread	Author	Time
Problem with pivot tables	Gabriel Filipiak	17:06
Re: Problem with pivot tables	Samuel Gendler	21:26

Nov. 7, 2011

Thread	Author	Time
ORACLE PROCEDURE TO POSTGRES FUNCTION -ERROR IN THE OVER PART	Manu T	07:18
Re: the use of $$string$$	Richard Huxton	08:44
Re: How to implement Aggregate Awareness?	Olgierd Michalak	19:25
Re: How to implement Aggregate Awareness?	Little, Douglas	20:03
GROUP and ORDER BY	Tarlika Elisabeth Schmitz	21:20

Nov. 8, 2011

Thread	Author	Time
Re: GROUP and ORDER BY	Robins Tharakan	04:27
Re: the use of $$string$$	Peter Eisentraut	05:16
Partitionning + Trigger and Execute not working as expected	Sylvain Mougenot	09:03
Re: Number timestamped rows	Jasen Betts	09:36
Re: the use of $$string$$	Jasen Betts	09:46
Re: GROUP and ORDER BY	Tarlika Elisabeth Schmitz	09:59
Issue with a variable in a function	tlund79	13:16

Browse Archives

Prev | Next