pgsql-sql since 2012-02-01 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

Feb. 1, 2012

Thread	Author	Time
Fw: Re: pg_dump not correctly saving schema with partitioned tables?	chester c young	00:42
Display Length Between Var & Varchar	Carlos Mennens	04:08
Re: Display Length Between Var & Varchar	Adrian Klaver	04:13
Re: Fw: Re: [SQL] pg_dump not correctly saving schema with partitioned tables?	Tom Lane	04:47
Re: MS-SQL Store Procedure to Postgresql Function	Jasen Betts	10:52

Feb. 2, 2012

Thread	Author	Time
Multiple tables query on Mapserver	tiplip	05:16
Re: Multiple tables query on Mapserver	David Johnston	05:22
Re: Multiple tables query on Mapserver	tiplip	05:32
Re: Multiple tables query on Mapserver	David Johnston	05:45
Re: Multiple tables query on Mapserver	tiplip	07:58
Re: MS-SQL Store Procedure to Postgresql Function	F. BROUARD / SQLpro	21:00
Re: MS-SQL Store Procedure to Postgresql Function	Pavel Stehule	21:20

Feb. 3, 2012

Thread	Author	Time
array dimensions, pg_catalog.pg_attribute and the \d command	Achilleas Mantzios	15:41
Re: array dimensions, pg_catalog.pg_attribute and the \d command	Dmitriy Igrishin	20:21

Feb. 5, 2012

Thread	Author	Time
Is there a way to remove every character but numbers?	Andreas	13:47
Re: Is there a way to remove every character but numbers?	Viktor Bojović	13:56

Feb. 6, 2012

Thread	Author	Time
type cast about int to bit	zoulx1982	06:11
Re: array dimensions, pg_catalog.pg_attribute and the \d command	Achilleas Mantzios	08:42
Re: type cast about int to bit	Jasen Betts	11:05

Feb. 7, 2012

Thread	Author	Time
Re: type cast about int to bit	Adrian Klaver	01:19
Re: type cast about int to bit	Adrian Klaver	03:28
problem with nested dblink function	Bear	14:00

Feb. 8, 2012

Thread	Author	Time
update multiple columns with multiple values	ssylla	07:39
Re: problem with nested dblink function	Bear	07:48
Concurrent Reindex on Primary Key for large table	rverghese	18:07
Re: Concurrent Reindex on Primary Key for large table	Thomas Kellerer	18:28
time interval math	Edward W. Rouse	20:01
Re: time interval math	Steve Crawford	20:25
Re: time interval math	Edward W. Rouse	20:49

Feb. 9, 2012

Thread	Author	Time
Re: time interval math	Tim Landscheidt	01:51
update column	ssylla	01:58
update column with multiple values	ssylla	02:31
Re: time interval math	Jasen Betts	11:36
Re: time interval math	Edward W. Rouse	14:31
Re: Concurrent Reindex on Primary Key for large table	rverghese	17:48

Feb. 10, 2012

Thread	Author	Time
Re: Concurrent Reindex on Primary Key for large table	Igor Neyman	14:41
Re: update column	Oliveiros d'Azevedo Cristina	15:33
Re: update column with multiple values	David Johnston	16:08

Feb. 11, 2012

Thread	Author	Time
Re: time interval math	Jasen Betts	03:18
Calling Postgresql Function to delete user data	Rehan Saleem	19:53

Feb. 12, 2012

Thread	Author	Time
Re: Calling Postgresql Function to delete user data	Philip Couling	13:02

Feb. 13, 2012

Thread	Author	Time
foreign key is it a real key	John Fabiani	15:46
Re: foreign key is it a real key	Andreas Kretschmer	15:50
Re: foreign key is it a real key	John Fabiani	17:30

Feb. 16, 2012

Thread	Author	Time
need help with import	Andreas	01:02
Re: need help with import	David Johnston	01:13
Re: need help with import	Andreas	02:05
Re: need help with import	David Johnston	02:41
Re: need help with import	Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=)	02:55
pg_dump - 8.3 - schemas	Edward W. Rouse	18:59
Re: pg_dump - 8.3 - schemas	Adrian Klaver	19:21
Re: pg_dump - 8.3 - schemas	Edward W. Rouse	19:31
Re: pg_dump - 8.3 - schemas	Adrian Klaver	19:38
Re: pg_dump - 8.3 - schemas	Edward W. Rouse	20:17
Re: pg_dump - 8.3 - schemas	Adrian Klaver	20:22

Feb. 17, 2012

Thread	Author	Time
Window function frame clause	vpapavas	01:01
Re: Window function frame clause	David Johnston	01:33
cast type bytea to double precision	Amila Jayasooriya	07:10
cast type bytea to double precision	Amila Jayasooriya	07:19
How can I use this subselect properly in an update?	John Tuliao	07:52
hstore and populate_record	Jan Eskilsson	12:12

Feb. 18, 2012

Thread	Author	Time
Re: Window function frame clause	vpapavas	02:52

Feb. 20, 2012

Thread	Author	Time
How to split up phone numbers?	Andreas	14:50
Re: How to split up phone numbers?	Filip Rembiałkowski	15:17

Feb. 21, 2012

Thread	Author	Time
Function definitions - batch update	Marcin Krawczyk	07:28
Re: Function definitions - batch update	Tom Lane	15:15
on insert rule with default value	Ron Peterson	20:51
Re: How to split up phone numbers?	Tim Landscheidt	21:40

Feb. 22, 2012

Thread	Author	Time
Re: Function definitions - batch update	Marcin Krawczyk	07:02
Another constant in foreign key problem.	Gary Stainburn	10:35
Re: Another constant in foreign key problem.	Oliveiros d'Azevedo Cristina	11:18
Re: Another constant in foreign key problem.	Gary Stainburn	11:25
Re: Another constant in foreign key problem.	Philip Couling	12:04
Re: Another constant in foreign key problem.	Gary Stainburn	12:19
Re: on insert rule with default value	Ron Peterson	13:52
Re: on insert rule with default value	Adrian Klaver	15:32
Re: Concurrent Reindex on Primary Key for large table	rverghese	21:07

Feb. 23, 2012

Thread	Author	Time
Re: How to split up phone numbers?	Jasen Betts	09:14

Feb. 24, 2012

Thread	Author	Time
crosstab help	John Fabiani	08:11
Re: crosstab help	Andreas Gaab	08:27
Re: crosstab help	John Fabiani	08:39
Re: crosstab help	Andreas Gaab	08:48
Re: crosstab help	John Fabiani	08:56
crosstab maybe by case statement	John Fabiani	16:32

Feb. 25, 2012

Thread	Author	Time
Problems with ODBC connections	Sandeep Reddy	18:05

Feb. 26, 2012

Thread	Author	Time
SQL View to PostgreSQL View	Rehan Saleem	18:50

Feb. 27, 2012

Thread	Author	Time
Re: SQL View to PostgreSQL View	Adrian Klaver	14:13
Re: Problems with ODBC connections	Adrian Klaver	14:17

Feb. 28, 2012

Thread	Author	Time
array_agg order by	jdmorgan	03:50
Re: array_agg order by	Tom Lane	04:15
How to convert SQL store procedure to Postgresql function	Rehan Saleem	08:50
Re: How to convert SQL store procedure to Postgresql function	Filip Rembiałkowski	10:36
Re: SQL View to PostgreSQL View	Mario Dankoor	11:29
Re: How to convert SQL store procedure to Postgresql function	Rehan Saleem	11:56
Re: How to convert SQL store procedure to Postgresql function	Rehan Saleem	12:00
Re: How to convert SQL store procedure to Postgresql function	Leif Biberg Kristensen	12:22
Re: Natural sort order	Richard Klingler	12:38
Re: SQL View to PostgreSQL View	Igor Neyman	14:27

Feb. 29, 2012

Thread	Author	Time
custom_variable_classes in 9.1	Marcin Krawczyk	09:29
How to shrink database in postgresql	Rehan Saleem	09:49
Re: How to shrink database in postgresql	Pavel Stehule	09:56
Re: custom_variable_classes in 9.1	Marcin Krawczyk	10:04
Re: Natural sort order	Tom Lane	16:08
Re: Natural sort order	Richard Klingler	16:14
date arithmetic with columns	Peter Faulks	19:50
Re: date arithmetic with columns	Peter Faulks	23:21

March 1, 2012

Thread	Author	Time
No sort with except	reto.buchli	08:13
Re: No sort with except	Frank Lanitz	08:16
Re: No sort with except	reto.buchli	08:56
Re: No sort with except	Jasen Betts	09:19
Re: No sort with except	Philip Couling	09:30
Aggregate and join problem	Swärd Mårten	10:30
Re: Aggregate and join problem	Oliveiros d'Azevedo Cristina	10:49
Re: Aggregate and join problem	Swärd Mårten	11:01
Re: Aggregate and join problem	Oliveiros d'Azevedo Cristina	11:04
Change Ownership Recursively	Carlos Mennens	16:23
Re: Change Ownership Recursively	Carlos Mennens	17:04
Re: Natural sort order	F. BROUARD / SQLpro	17:23
Re: Change Ownership Recursively	Adrian Klaver	18:36
Re: Change Ownership Recursively	Carlos Mennens	19:37
Re: Change Ownership Recursively	Adrian Klaver	19:44

March 2, 2012

Thread	Author	Time
How To Create Temporary Table inside a function	Rehan Saleem	11:23
Re: How To Create Temporary Table inside a function	Philip Couling	11:49
Problems with non use of indexes	tylersticky@gmail.com	12:17
Re: How to shrink database in postgresql	Mario Marín	12:29
Re: Change Ownership Recursively	Emi Lu	16:56
Re: Problems with ODBC connections	Sandeep Reddy	19:41
Re: How To Create Temporary Table inside a function	Samuel Gendler	22:17

March 3, 2012

Thread	Author	Time
Re: date arithmetic with columns	Pavel Stehule	10:24

March 4, 2012

Thread	Author	Time
Re: Problems with ODBC connections	Jasen Betts	08:56
Re: date arithmetic with columns	hari.fuchs	09:45
Re: date arithmetic with columns	Peter Faulks	11:29

March 6, 2012

Thread	Author	Time
pg_dump : no tables were found.	Piyush Lenka	06:22
Re: [ADMIN] pg_dump : no tables were found.	Julien Rouhaud	10:44
map row in one table with random row in another table	rverghese	21:00

March 7, 2012

Thread	Author	Time
Re-Sync Stand By Server	Adam Cornett	18:28
Type Ahead Issue	Carlos Mennens	18:42
Re: Type Ahead Issue	Tom Lane	20:37
Re: map row in one table with random row in another table	Igor Neyman	20:38
Re: map row in one table with random row in another table	rverghese	20:48

March 12, 2012

Thread	Author	Time
crosstab	John Fabiani	16:58
Re: crosstab	Pavel Stehule	17:01
Re: crosstab	John Fabiani	18:07
Re: crosstab	Pavel Stehule	18:11

March 13, 2012

Thread	Author	Time
Invalid syntax for integer	Rehan Saleem	18:25
help on a function with exception	M. D.	18:29
Re: Invalid syntax for integer	David Johnston	18:34

March 14, 2012

Thread	Author	Time
Re: help on a function with exception	David Johnston	12:30

March 15, 2012

Thread	Author	Time
COPY without quoting	Lee Hachadoorian	16:16
Re: COPY without quoting	Tom Lane	16:23
Re: COPY without quoting	Lee Hachadoorian	16:52

March 19, 2012

Thread	Author	Time
Postgresql function which compares values from both tables	Rehan Saleem	19:40
Re: Postgresql function which compares values from both tables	David Johnston	20:04
Re: Postgresql function which compares values from both tables	Richard Huxton	20:59
Re: Postgresql function which compares values from both tables	David Johnston	22:14

March 20, 2012

Thread	Author	Time
Re: Postgresql function which compares values from both tables	Jayadevan M	03:21
Setting the process title, or can I?	Bèrto ëd Sèra	10:14
Re: Setting the process title, or can I?	Frank Bax	11:26
Re: Setting the process title, or can I?	Bèrto ëd Sèra	11:33
Re: Setting the process title, or can I?	Steve Crawford	15:18
Re: Setting the process title, or can I?	Bèrto ëd Sèra	15:24

March 21, 2012

Thread	Author	Time
Problem with inserting data produced by the function (when the function is performed).	Bear	08:30

March 22, 2012

Thread	Author	Time
Fill array with series	Lee Hachadoorian	19:47
Re: Fill array with series	Pavel Stehule	20:02
ignore case in where clause	Edward W. Rouse	20:26
Re: ignore case in where clause	Guillaume Lelarge	20:38
Re: ignore case in where clause	Edward W. Rouse	21:05

March 23, 2012

Thread	Author	Time
Can I read the data without commit	John Fabiani	21:33
Re: Can I read the data without commit	Jonathan S. Katz	21:40
Re: Can I read the data without commit	Rob Sargent	21:46
Re: Can I read the data without commit	John Fabiani	21:49
Re: Can I read the data without commit	Rob Sargent	22:00
Re: Can I read the data without commit	John Fabiani	22:11
Re: Can I read the data without commit	Tim Landscheidt	22:25

March 24, 2012

Thread	Author	Time
how to concatenate in PostgreSQL	Rehan Saleem	11:43
Re: how to concatenate in PostgreSQL	Andreas Kretschmer	11:57
Re: how to concatenate in PostgreSQL	Allan Kamau	13:42

March 26, 2012

Thread	Author	Time
MS-SQL to PostgreSql	Rehan Saleem	07:49
Postgresql function with temporary tables	Rehan Saleem	10:01
Re: MS-SQL to PostgreSql	Robins Tharakan	10:03
Re: how to concatenate in PostgreSQL	Robins Tharakan	10:15
Re: MS-SQL to PostgreSql	Robins Tharakan	10:25
Re: how to concatenate in PostgreSQL	Steve Crawford	16:08

March 27, 2012

Thread	Author	Time
Re: how to concatenate in PostgreSQL	Steve Crawford	16:12

March 28, 2012

Thread	Author	Time
Wrong output from union	Gary Stainburn	14:01

March 31, 2012

Thread	Author	Time
Re: Wrong output from union	David Johnston	01:19

April 2, 2012

Thread	Author	Time
Re: Wrong output from union	Gary Stainburn	09:11

April 3, 2012

Thread	Author	Time
How to write cursors	La Chi	07:44
Cursor Error	La Chi	09:23
Re: Wrong output from union	Jasen Betts	10:49
Duplicate information in parent and child tables	JORGE MALDONADO	22:03

April 4, 2012

Thread	Author	Time
Re: Duplicate information in parent and child tables	msi77	04:16
how to write cursors	La Chi	07:30
Re: how to write cursors	Pavel Stehule	07:36

April 5, 2012

Thread	Author	Time
bad plan 📎	Julien Cigar	11:38
Re: bad plan	Mario Dankoor	12:03
Re: bad plan 📎	Julien Cigar	12:08
Re: bad plan	Mario Dankoor	12:32
Re: bad plan 📎	Julien Cigar	12:43
Re: bad plan 📎	Julien Cigar	14:29

Browse Archives

Prev | Next