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

April 6, 2012

Thread	Author	Time
syntax of joins	Andreas	18:58
Re: syntax of joins	Pavel Stehule	19:23
Re: syntax of joins	Rob Sargent	19:28
Re: syntax of joins	Pavel Stehule	19:46
Re: syntax of joins	Rob Sargent	20:14

April 10, 2012

Thread	Author	Time
How to html-decode a html-encoded field	JORGE MALDONADO	15:59
Re: How to html-decode a html-encoded field	Pavel Stehule	16:01

April 11, 2012

Thread	Author	Time
Re: sintax error	kevalshah	11:57
Re: sintax error	Tom Lane	14:29
Re: Pregunta acerca de la función COPY de POSTGRES	yeison garcia	17:42
UPDATE Multiple Records At Once?	Carlos Mennens	17:50
Re: UPDATE Multiple Records At Once?	lewbloch	19:20
Re: Re: Pregunta acerca de la función COPY de POSTGRES	Edward Ross	20:43
Re: UPDATE Multiple Records At Once?	Thomas Kellerer	20:55
ERROR: operator does not exist: integer = integer[]	cesar_cast	21:01

April 12, 2012

Thread	Author	Time
Re: How to html-decode a html-encoded field	Jasen Betts	12:26

April 16, 2012

Thread	Author	Time
Re: ERROR: operator does not exist: integer = integer[]	Pavel Stehule	14:30

April 18, 2012

Thread	Author	Time
Uniform UPDATE queries	Dennis	10:11
Re: Uniform UPDATE queries	Rob Sargent	15:10
Re: Uniform UPDATE queries	Tom Lane	16:24
plpgsql : adding record variable to table	thomas veymont	17:41
plpgsql : adding record variable to table	thomas veymont	17:55
Re: plpgsql : adding record variable to table	Pavel Stehule	18:03

April 19, 2012

Thread	Author	Time
Re: plpgsql : adding record variable to table	thomas veymont	09:43
Re: plpgsql : adding record variable to table	Pavel Stehule	10:08
Re: Uniform UPDATE queries	Dennis	10:55
Re: plpgsql : adding record variable to table	thomas veymont	11:56
Re: plpgsql : adding record variable to table	Pavel Stehule	11:58
Re: Uniform UPDATE queries	Rob Sargent	18:32

April 23, 2012

Thread	Author	Time
getting the OS user name	John Fabiani	14:28
Re: getting the OS user name	Andreas Kretschmer	14:52
Re: getting the OS user name	John Fabiani	14:57

April 24, 2012

Thread	Author	Time
Re: getting the OS user name	Jasen Betts	09:48
Simple way to get missing number	Emi Lu	14:15
Re: Simple way to get missing number	hubert depesz lubaczewski	14:31
Re: Simple way to get missing number	Andreas Kretschmer	14:36
Re: Simple way to get missing number	Alban Hertroys	14:41
Re: Simple way to get missing number	Emi Lu	15:21
Re: Simple way to get missing number	Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=)	15:29
Re: [SQL] Simple way to get missing number	Steve Crawford	15:42
Re: Simple way to get missing number	Andreas Kretschmer	16:06
Re: [SQL] Simple way to get missing number	Emi Lu	18:10
How to group by similarity?	Andreas	18:39
Re: [SQL] Simple way to get missing number	Steve Crawford	18:56
generic crosstab ?	Andreas	20:01
Re: generic crosstab ?	Samuel Gendler	20:08
Re: generic crosstab ?	Andreas	21:34
Re: generic crosstab ?	David Johnston	21:42
Re: generic crosstab ?	Joe Conway	22:04
Re: generic crosstab ?	Andreas	22:37

April 25, 2012

Thread	Author	Time
Re: generic crosstab ?	Pavel Stehule	03:46
Re: How to group by similarity?	Trinath Somanchi	03:46
Re: generic crosstab ?	Samuel Gendler	05:07
Regarding report generated by the pgFouine	Venkateswara Rao Dokku	05:55
How can this INSERT fail?	Peter Harris	11:45
Re: How can this INSERT fail?	Abbas	12:29
Re: How can this INSERT fail?	Peter Harris	13:01
Re: How can this INSERT fail?	Greg Sabino Mullane	17:26

April 26, 2012

Thread	Author	Time
Running mean filtering using Window Functions?	Andreas Gaab	09:22

May 2, 2012

Thread	Author	Time
pg_dump: aborting because of server version mismatch	Mitesh Shah	19:55
pg_dump: aborting because of server version mismatch	Mitesh Shah	19:58
pg_dump: aborting because of server version mismatch	Mitesh Shah	20:23
Re: pg_dump: aborting because of server version mismatch	Albin, Lloyd P	21:01
Re: [BUGS] pg_dump: aborting because of server version mismatch	Kevin Grittner	21:53
Re: [seapug] Re: [BUGS] pg_dump: aborting because of server version mismatchT	Robert Bernier	22:27

May 3, 2012

Thread	Author	Time
Re: [sfpug] pg_dump: aborting because of server version mismatch	Christophe Pettus	03:27

May 4, 2012

Thread	Author	Time
How change col name during query to use it in where clause	Marcel Ruff	10:25
Re: How change col name during query to use it in where clause	Andreas Kretschmer	12:40
Re: How change col name during query to use it in where clause	Oliveiros d'Azevedo Cristina	12:43
Re: How change col name during query to use it in where clause	Thomas Kellerer	13:05

May 11, 2012

Thread	Author	Time
Finding Max Value in a Row	Carlos Mennens	19:03
Re: Finding Max Value in a Row	Viktor Bojović	19:17
Re: Finding Max Value in a Row	Wes James	19:17
Re: Finding Max Value in a Row	David Johnston	19:20
Re: Finding Max Value in a Row	Thomas Kellerer	19:24
Re: Finding Max Value in a Row	Carlos Mennens	19:30
Re: [SQL] pg_dump: aborting because of server version mismatch	Adrian Klaver	19:39
Re: Finding Max Value in a Row	Adrian Klaver	19:43
Re: Finding Max Value in a Row	Thomas Kellerer	19:44
Re: Finding Max Value in a Row	Carlos Mennens	19:50
Re: Finding Max Value in a Row	Carlos Mennens	19:53
Re: Finding Max Value in a Row	Thomas Kellerer	20:00
Re: Finding Max Value in a Row	Thomas Kellerer	20:05
Re: Finding Max Value in a Row	Viktor Bojović	20:42
Re: Finding Max Value in a Row	Jasen Betts	21:59

May 12, 2012

Thread	Author	Time
syncing - between databases	John Fabiani	14:28

Browse Archives

Prev | Next