pgsql-sql since 2008-04-19 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

April 19, 2008

Thread Author Time
Re: Desc Commnad in pgsql? Christopher Browne 16:55

April 20, 2008

Thread Author Time
Re: How to find double entries Jean-David Beyer 01:54

April 21, 2008

Thread Author Time
Re: Desc Commnad in pgsql? TJ O'Donnell 00:14
Re: Desc Commnad in pgsql? Alvaro Herrera 13:36
Having a mental block with (self) outer joins Thomas Kellerer 13:48
Re: Having a mental block with (self) outer joins hubert depesz lubaczewski 14:05
Re: Having a mental block with (self) outer joins Thomas Kellerer 14:15
Re: Error: could not find pathkey item to sort Tom Lane 14:23

April 22, 2008

Thread Author Time
Error: could not find pathkey item to sort Theerasak Maneeneim 01:09
Problems with function while migrating from Windows to Linux Jan Peters 09:47
After updating dataset the record goes to the end of the dataset Nacef LABIDI 09:54
Re: After updating dataset the record goes to the end of the dataset Nacef LABIDI 10:10
Re: After updating dataset the record goes to the end of the dataset Thomas Kellerer 10:11
Re: After updating dataset the record goes to the end of the dataset Gurjeet Singh 10:12
Re: After updating dataset the record goes to the end of the dataset hubert depesz lubaczewski 10:15
Re: After updating dataset the record goes to the end of the dataset Nacef LABIDI 10:31
Re: After updating dataset the record goes to the end of the dataset Pavan Deolasee 10:45
Re: After updating dataset the record goes to the end of the dataset hubert depesz lubaczewski 11:02
Re: After updating dataset the record goes to the end of the dataset 📎 Padam J Singh 11:02
Re: Problems with function while migrating from Windows to Linux Craig Ringer 12:30
Re: After updating dataset the record goes to the end of the dataset Craig Ringer 12:46
Re: After updating dataset the record goes to the end of thedataset Bart Degryse 12:56
Re: After updating dataset the record goes to the end of thedataset Nacef LABIDI 13:00
Re: After updating dataset the record goes to the end of thedataset Scott Marlowe 15:16
Problem with FOREIGN KEY Вадим Жерновой | =?UTF-8?Q?Vadim_Zhernovoi|?= 15:26
Re: Problem with FOREIGN KEY Erik Jones 15:37
Re: Problem with FOREIGN KEY D'Arcy J.M. Cain 16:01
extracting words Tarlika Elisabeth Schmitz 21:25

April 23, 2008

Thread Author Time
Re: extracting words A. Kretschmer 05:18
Re: extracting words Alvaro Herrera 13:13
Re: extracting words Tarlika Elisabeth Schmitz 14:57

April 24, 2008

Thread Author Time
First day of month, last day of month Nacef LABIDI 12:59
Re: First day of month, last day of month Frank Bax 13:06
Re: First day of month, last day of month Bart Degryse 13:11
Re: First day of month, last day of month A. Kretschmer 13:15
Re: First day of month, last day of month Frank Bax 13:16
How I can check a substring is a valid number in postgresql ? Anoop G 13:34
Re: How I can check a substring is a valid number in postgresql ? Volkan YAZICI 13:53
Re: First day of month, last day of month Colin Wetherbee 14:15
Re: First day of month, last day of month Erik Jones 14:41
Re: First day of month, last day of month Bart Degryse 14:42
Re: First day of month, last day of month Nacef LABIDI 14:43
Re: First day of month, last day of month Bart Degryse 14:47
Re: First day of month, last day of month Terry Lee Tucker 14:52
Re: First day of month, last day of month Scott Marlowe 14:55
Re: First day of month, last day of month Scott Marlowe 14:56
Re: First day of month, last day of month Erik Jones 15:07
Re: First day of month, last day of month Erik Jones 15:08
Re: First day of month, last day of month Bart Degryse 15:08
Re: First day of month, last day of month Fernando Hevia 15:10
Re: First day of month, last day of month Scott Marlowe 15:16
Re: How I can check a substring is a valid number in postgresql ? TJ O'Donnell 15:43
Re: First day of month, last day of month Scott Marlowe 15:44
Re: First day of month, last day of month Fernando Hevia 16:07
Re: extracting words Tarlika Elisabeth Schmitz 16:12
Re: First day of month, last day of month Nacef LABIDI 16:39

April 25, 2008

Thread Author Time
trim(both) problem? Emi Lu 20:33
Re: trim(both) problem? Tom Lane 20:44
Re: trim(both) problem? Stephan Szabo 20:45
Re: trim(both) problem? Fernando Hevia 21:03
Re: trim(both) problem? Tom Lane 21:26
Re: trim(both) problem? chester c young 21:48

April 26, 2008

Thread Author Time
Protection from SQL injection Thomas Mueller 16:32
Re: Protection from SQL injection Tom Lane 17:05
Re: Protection from SQL injection Jaime Casanova 18:16
Fwd: Protection from SQL injection Thomas Mueller 18:16
Re: Protection from SQL injection Thomas Mueller 18:19
Re: Protection from SQL injection Jaime Casanova 21:31
Re: Protection from SQL injection Thomas Kellerer 21:32

April 27, 2008

Thread Author Time
Re: Protection from SQL injection Scott Marlowe 00:21
Re: Protection from SQL injection Tom Lane 03:42
Re: Protection from SQL injection Scott Marlowe 03:50
Re: Protection from SQL injection Tom Lane 03:58
Re: Protection from SQL injection Scott Marlowe 05:24
Re: Protection from SQL injection Thomas Mueller 07:08
Re: Protection from SQL injection Thomas Mueller 08:48
Re: Protection from SQL injection Thomas Mueller 09:08
Re: Protection from SQL injection Thomas Mueller 09:14
Re: Protection from SQL injection Ivan Sergio Borgonovo 09:29
Re: Protection from SQL injection Ivan Sergio Borgonovo 10:38
Re: Protection from SQL injection Ivan Sergio Borgonovo 12:22
Curious about wide tables. Jean-David Beyer 13:01
Re: Curious about wide tables. Shane Ambler 15:32
Re: Protection from SQL injection Joe 15:55
Re: Curious about wide tables. Jonah H. Harris 16:06
Re: Curious about wide tables. Mag Gam 16:14
Re: Protection from SQL injection Ivan Sergio Borgonovo 17:18
Re: Protection from SQL injection Joe 18:25
Re: Protection from SQL injection Thomas Mueller 18:43
psql: no schema info chester c young 21:33
Re: psql: no schema info Tom Lane 22:36
Re: psql: no schema info chester c young 23:33

April 28, 2008

Thread Author Time
Re: psql: no schema info Alvaro Herrera 00:05
Re: psql: no schema info Richard Huxton 07:30
Re: trim(both) problem? Emi Lu 13:19
Re: psql: no schema info chester c young 17:01
information_schema.referential_constraints permissions Lodewijk Voege 21:47
currval of sequence "my_seq" is not yet defined in this session Nacef LABIDI 22:33
Truncate table at a certain size. Dana Huggard - Navarik 22:35
Re: information_schema.referential_constraints permissions Tom Lane 23:14

April 29, 2008

Thread Author Time
Re: Truncate table at a certain size. Gurjeet Singh 01:24
Re: currval of sequence "my_seq" is not yet defined in this session Scott Marlowe 02:22
Re: Truncate table at a certain size. Scott Marlowe 03:31
Field Alias Alternative Bart Degryse 07:20
Reg:-How to make relationship more one table in PgSQL venkat 11:10
Re: Reg:-How to make relationship more one table in PgSQL kapil.munish 11:21
Re: Reg:-How to make relationship more one table in PgSQL Mag Gam 17:24

April 30, 2008

Thread Author Time
Re: Curious about wide tables. Jean-David Beyer 14:25
columns for count histograms of values Alexy Khrabrov 21:01
Re: columns for count histograms of values chester c young 23:12

May 1, 2008

Thread Author Time
Re: columns for count histograms of values Mag Gam 01:32
Re: columns for count histograms of values Alexy Khrabrov 08:35

May 2, 2008

Thread Author Time
numbering rows on import from file Alexy Khrabrov 21:26
Re: numbering rows on import from file chester c young 22:33
Re: numbering rows on import from file Scott Marlowe 23:00

May 3, 2008

Thread Author Time
Re: numbering rows on import from file Steve Crawford 00:18
update with multiple fields as aggregates Alexy Khrabrov 08:05
Re: update with multiple fields as aggregates Volkan YAZICI 14:36

May 4, 2008

Thread Author Time
LEFT OUTER JOIN question seiliki 16:28
Re: LEFT OUTER JOIN question Craig Ringer 16:40
Re: LEFT OUTER JOIN question Aaron Bono 16:46
Re: LEFT OUTER JOIN question Frank Bax 16:54

May 6, 2008

Thread Author Time
Working with dates before 4713 BC Ryan Wallace 00:22
Re: Working with dates before 4713 BC Tom Lane 01:17
Re: Working with dates before 4713 BC Phillip Smith 01:28
Database normalization Sid 'Neko Tamashii' 11:06
Re: Database normalization Richard Huxton 12:28
Re: Database normalization Sid 'Neko Tamashii' 12:33

May 7, 2008

Thread Author Time
dbmirror - migration to 8.3 from 7.4 Achilleas Mantzios 11:42
Re: dbmirror - migration to 8.3 from 7.4 Claus Guttesen 11:49
Re: dbmirror - migration to 8.3 from 7.4 Claus Guttesen 11:51
Re: dbmirror - migration to 8.3 from 7.4 Achilleas Mantzios 11:52
Insert with pl/pgsql trigger Woody Woodring 14:36
Re: how to check if a point is contained in a polygon ? Richard Huxton 14:38
Re: how to check if a point is contained in a polygon ? Tom Lane 15:12
Re: Insert with pl/pgsql trigger Tom Lane 15:24
how to check if a point is contained in a polygon ? Julien Cigar 16:25
Re: how to check if a point is contained in a polygon ? Julien Cigar 17:00

May 8, 2008

Thread Author Time
Joining with result of a plpgsql function Matthew T. O'Connor 03:28
Re: Joining with result of a plpgsql function Stephan Szabo 04:07
Re: Joining with result of a plpgsql function Matthew T. O'Connor 05:21
Index to enforce non-overlapping ranges? James Robinson 13:27
Re: Index to enforce non-overlapping ranges? Chris Browne 14:31
Re: Index to enforce non-overlapping ranges? Tom Lane 14:54

May 9, 2008

Thread Author Time
execute plpgsl like "normal" sql Christian Kindler 10:00
Re: execute plpgsl like "normal" sql Christian Kindler 15:00

May 11, 2008

Thread Author Time
Difference in columns Mag Gam 17:37
Re: Difference in columns chester c young 17:54
Re: Difference in columns Gurjeet Singh 17:55
Re: Difference in columns hubert depesz lubaczewski 18:11
Re: Difference in columns Craig Ringer 18:17
Re: Difference in columns Gurjeet Singh 18:36
Re: Difference in columns Tom Lane 18:58
Re: Difference in columns Craig Ringer 19:58

May 12, 2008

Thread Author Time
Re: Difference in columns Mag Gam 00:58
merge timestamps to intervals Patrick Scharrenberg 05:38
Re: merge timestamps to intervals Craig Ringer 06:33
Re: merge timestamps to intervals Andreas Kretschmer 06:56

May 13, 2008

Thread Author Time
Auto-formatting timestamps? Peter Koczan 15:58
Re: Auto-formatting timestamps? Mag Gam 22:54
Add a ROWCOUNT to the output of a select. Gavin 'Beau' Baumanis 23:54

May 14, 2008

Thread Author Time
Re: Add a ROWCOUNT to the output of a select. Gurjeet Singh 00:33
Re: Add a ROWCOUNT to the output of a select. Robins Tharakan 01:18
Re: Add a ROWCOUNT to the output of a select. Marcin Stępnicki 08:34
Re: Add a ROWCOUNT to the output of a select. Harald Fuchs 08:40
Re: Add a ROWCOUNT to the output of a select. Marcin Stępnicki 08:48
Re: Add a ROWCOUNT to the output of a select. Robins Tharakan 10:01
Re: Auto-formatting timestamps? Peter Koczan 15:46
Re: Auto-formatting timestamps? Alvaro Herrera 15:59

May 15, 2008

Thread Author Time
Re: Auto-formatting timestamps? Mag Gam 02:46
Query tuning kapil.munish 06:00
xpath_table Thomas Kellerer 11:37

May 16, 2008

Thread Author Time
Re: Query tuning Moiz Kothari 11:50
Find all instances of a column in the entire database. Gavin 'Beau' Baumanis 13:51
Re: Find all instances of a column in the entire database. hubert depesz lubaczewski 13:56
Re: Find all instances of a column in the entire database. Gavin 'Beau' Baumanis 14:04
Re: Find all instances of a column in the entire database. A. Kretschmer 14:27
Re: Query tuning Scott Marlowe 15:21
Re: Query tuning Simon Riggs 16:13
Re: Find all instances of a column in the entire database. Chris Browne 16:21

May 17, 2008

Thread Author Time
dblinks sumaya 22:58
Re: dblinks Jonah H. Harris 23:31

May 18, 2008

Thread Author Time
Re: dblinks sumaya 08:47
Re: dblinks sumaya 09:25
Re: dblinks Jonah H. Harris 12:02

May 19, 2008

Thread Author Time
Re: dblinks Ramasubramanian G 03:06
Re: dblinks Dave Page 08:22
Supplying a default on read, if a column does not exist in DB Bryce Nesbitt 21:48

May 20, 2008

Thread Author Time
SQL question.... Karl Denninger 18:14
Re: SQL question.... chester c young 19:06
Re: SQL question.... Karl Denninger 19:17
Re: SQL question.... Harold A. Giménez Ch. 19:54
Re: SQL question.... Gurjeet Singh 20:57
Re: SQL question.... Karl Denninger 23:17

May 21, 2008

Thread Author Time
Re: SQL question.... Gurjeet Singh 02:53
Re: SQL question.... Karl Denninger 03:03
Re: SQL question.... Gurjeet Singh 07:52
Re: SQL question.... Karl Denninger 11:39

May 22, 2008

Thread Author Time
Re: SQL question.... Steve Midgley 00:42
Re: SQL question.... Karl Denninger 01:12

Browse Archives

Prev | Next