pgsql-sql since 2008-03-20 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

March 20, 2008

Thread Author Time
Re: Date and filling issues Osvaldo Kussama 02:36
Re: compare 2 tables in sql Tena Sakai 02:45
Re: Date and filling issues Rodrigo E. De León Plicet 03:03
Select into Gavin 'Beau' Baumanis 09:57
Re: Select into A. Kretschmer 10:49
Re: Select into Gurjeet Singh 10:58
Re: Select into Gavin 'Beau' Baumanis 11:09
Re: Select into Greg Sabino Mullane 11:39
Re: Select into Gurjeet Singh 12:03
Re: Select into Craig Ringer 12:05
Re: Select into Joe 12:10
Re: Select into Gurjeet Singh 12:14
Re: Select into Gavin 'Beau' Baumanis 12:20
Re: Select into Craig Ringer 12:49
Re: Select into Gurjeet Singh 13:13
Re: Select into Joe 13:38
Rollback locks table - why? Jan Peters 13:42
Rollback locks table - why? Jan Peters 13:44
Re: Select into Craig Ringer 13:44
Re: Rollback locks table - why? Craig Ringer 13:57
Re: Rollback locks table - why? Jan Peters 14:30
Re: Select into Gurjeet Singh 14:30
Re: Rollback locks table - why? Craig Ringer 14:34
Re: Rollback locks table - why? Jan Peters 15:00
Re: Select into Erik Jones 15:05
Re: Rollback locks table - why? Tom Lane 15:11
Re: Rollback locks table - why? Jan Peters 15:17
Re: Rollback locks table - why? Jan Peters 15:20
Re: Rollback locks table - why? Jan Peters 15:37
Re: compare 2 tables in sql Tena Sakai 17:44
Re: compare 2 tables in sql Jonah H. Harris 19:21
Re: compare 2 tables in sql Tena Sakai 20:04
Dynamic sql and variable record types Erik Jones 22:28
Re: Date and filling issues chester c young 23:02

March 21, 2008

Thread Author Time
Testing DDL Ian Tegebo 09:41
SOLVED - Re: Dynamic sql and variable record types Erik Jones 16:21

March 25, 2008

Thread Author Time
Deferrable NOT NULL REFERENCES ... for two-way referential relationship Craig Ringer 07:55
Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship (SOLVED?) Craig Ringer 13:56
Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship Tom Lane 15:07
copy command and array of composite types? Jon Norman 18:19
Re: copy command and array of composite types? Guy Fraser 20:12

March 26, 2008

Thread Author Time
Export Access 97 to PostgreSQL Shavonne Marietta Wijesinghe 11:46
Part 1 of several - Converting a varchar to an interval Shawn 15:56
Question 2 Interval and timestamptz Shawn 16:05
Re: Export Access 97 to PostgreSQL Shane Ambler 16:15
Re: Export Access 97 to PostgreSQL Shawn 16:21
Re: Part 1 of several - Converting a varchar to an interval Shawn 16:27
FW: Re: Part 1 of several - Converting a varchar to an interval Adrian Klaver 16:32
FW: Re: Question 2 Interval and timestamptz Adrian Klaver 16:33
Re: Question 2 Interval and timestamptz Shawn 16:34
Re: FW: Re: Part 1 of several - Converting a varchar to an interval Tom Lane 17:14
Re: FW: Re: Part 1 of several - Converting a varchar to an interval Adrian Klaver 17:21
Re: FW: Re: Part 1 of several - Converting a varchar to an interval Adrian Klaver 17:30
Bizarre sort order Conlon, Joseph F SIK 17:55
Re: FW: Re: Part 1 of several - Converting a varchar to an interval Tom Lane 18:14
Finding all References to a Primary Key Matthew T. O'Connor 18:19
Re: Bizarre sort order Tom Lane 19:26
Re: FW: Re: Part 1 of several - Converting a varchar to an interval Adrian Klaver 20:02
Re: FW: Re: Part 1 of several - Converting a varchar to an interval Shawn 22:45
Re: FW: Re: Part 1 of several - Converting a varchar to an interval Rodrigo E. De León Plicet 23:12
Re: FW: Re: Part 1 of several - Converting a varchar to an interval Shawn 23:41

March 27, 2008

Thread Author Time
Dropping Functions Shawn 00:05
Re: Dropping Functions Adrian Klaver 00:13
Re: Dropping Functions Shawn 00:25
Re: Export Access 97 to PostgreSQL Shavonne Marietta Wijesinghe 09:03
Re: Export Access 97 to PostgreSQL Ivan Sergio Borgonovo 09:54
Re: Export Access 97 to PostgreSQL Shavonne Marietta Wijesinghe 10:06
Re: Export Access 97 to PostgreSQL Marcin Stępnicki 10:14
Re: Export Access 97 to PostgreSQL Shavonne Marietta Wijesinghe 10:16
Re: Export Access 97 to PostgreSQL Roberto Spier 12:16
link to Jsp Shavonne Marietta Wijesinghe 14:47
Re: Finding all References to a Primary Key Erik Jones 15:24
Re: link to Jsp Craig Ringer 18:02
returning on inserts chester c young 19:24

March 31, 2008

Thread Author Time
Removing redundant itemsets Allan Kamau 08:16
Re: Removing redundant itemsets Allan Kamau 09:58
Re: Removing redundant itemsets Craig Ringer 10:53
Re: Removing redundant itemsets Craig Ringer 11:29
Re: Removing redundant itemsets Craig Ringer 11:48
drop table where tableName like 'backup_2007%' ? Emi Lu 14:48
Re: drop table where tableName like 'backup_2007%' ? Tom Lane 15:55
Re: drop table where tableName like 'backup_2007%' ? Richard Huxton 16:27
specifying wal file size gherzig 23:41

April 1, 2008

Thread Author Time
Re: specifying wal file size Tom Lane 04:45
difference between EXCEPT and NOT IN? Raphael Bauduin 15:50
Re: difference between EXCEPT and NOT IN? Stephan Szabo 16:04
Re: difference between EXCEPT and NOT IN? Raphael Bauduin 16:43
Sequential non unique IDs John Reeve 22:49

April 2, 2008

Thread Author Time
Re: Sequential non unique IDs Craig Ringer 04:24
Re: Sequential non unique IDs Volkan YAZICI 05:48
A sys func for a->b, b->c => a->c ? Emi Lu 14:21
apparent RI bug chester c young 17:42
update with join Ivan Sergio Borgonovo 20:47

April 3, 2008

Thread Author Time
Asking GO on SQL SERVER Otniel Michael 01:44
Re: Asking GO on SQL SERVER paul rivers 01:55
Re: Asking GO on SQL SERVER Gurjeet Singh 02:09
Re: Asking GO on SQL SERVER Otniel Michael 02:12
Re: update with join Osvaldo Kussama 02:54
Re: Asking GO on SQL SERVER Phillip Smith 03:06
Re: update with join Ivan Sergio Borgonovo 08:53
BROBLEM IN BETWEEN QUERY (plpgsql) Anoop G 10:24
Re: BROBLEM IN BETWEEN QUERY (plpgsql) A. Kretschmer 11:09
GiST/GIN index for field of type VARCHAR[] Yura Gal 15:38
connections between servers Marcin Krawczyk 17:00
Re: apparent RI bug Stephan Szabo 17:31
Re: connections between servers Shane Ambler 17:35
Re: apparent RI bug chester c young 18:13
Re: apparent RI bug Stephan Szabo 18:33
Re: connections between servers Marcin Krawczyk 19:26
Re: apparent RI bug chester c young 20:16
Re: apparent RI bug Stephan Szabo 20:35

April 4, 2008

Thread Author Time
Re: apparent RI bug chester c young 01:53

April 5, 2008

Thread Author Time
Problem with now() in function pgsql [email protected] 17:46
Re: Problem with now() in function pgsql Adrian Klaver 17:59

April 7, 2008

Thread Author Time
Re: Sequential non unique IDs John Reeve 03:18
undefined relations in pg_locks Sabin Coanda 08:56
pl/PgSQL, variable names in NEW Martin Edlman 11:19
Re: pl/PgSQL, variable names in NEW Pavel Stehule 12:11
Problem commit in function [email protected] 12:30
Re: Problem commit in function Pavan Deolasee 12:36
Commit every processed record [email protected] 12:46
how to returns set of records in PL/python Anoop G 12:47
Re: Commit every processed record A. Kretschmer 13:01
Re: how to returns set of records in PL/python Gerardo Herzig 13:03
Re: how to returns set of records in PL/python Gerardo Herzig 13:04
Re: Problem commit in function Craig Ringer 13:36
Re: Commit every processed record Craig Ringer 13:38
Re: undefined relations in pg_locks Tom Lane 14:03
Re: Commit every processed record Bart Degryse 14:22
advocacy: case studies Ivan Sergio Borgonovo 20:33
Re: advocacy: case studies Erik Jones 23:17

April 8, 2008

Thread Author Time
Re: pl/PgSQL, variable names in NEW Martin Edlman 11:06
Re: pl/PgSQL, variable names in NEW Alvaro Herrera 13:21
Pattern Matchig Tk421 17:14
Re: Pattern Matchig Alvaro Herrera 17:24
Re: Pattern Matchig 📎 Tk421 17:39

April 9, 2008

Thread Author Time
count question novice 01:51
Re: count question Craig Ringer 02:11
Re: count question rdeleonp 03:34
Re: count question Volkan YAZICI 05:37
Re: count question ashish 06:00
Re: undefined relations in pg_locks Sabin Coanda 07:06
(no subject) Colin Martin 12:07

April 10, 2008

Thread Author Time
dateformat issue Gavin 'Beau' Baumanis 00:14
Re: dateformat issue Aarni Ruuhimäki 06:17
Re: dateformat issue Gavin 'Beau' Baumanis 06:41
Re: dateformat issue Aarni Ruuhimäki 07:27
Re: dateformat issue Tk421 11:19
Re: pl/PgSQL, variable names in NEW Martin Edlman 11:34
Re: dateformat issue Volkan YAZICI 12:37
Re: [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera 13:16
Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane 14:45
Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Joshua D. Drake 14:51
Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Andrew Dunstan 14:56
Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane 14:58
Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera 15:21

April 11, 2008

Thread Author Time
Testing for null record in plpgsql Erik Jones 04:16
Re: Testing for null record in plpgsql Pavel Stehule 05:21
Re: Testing for null record in plpgsql Craig Ringer 07:40
Re: Testing for null record in plpgsql Erik Jones 14:35
Get the last inserted id Nacef LABIDI 17:23
Re: Get the last inserted id Scott Marlowe 17:41
Re: Get the last inserted id Nacef LABIDI 17:43
Re: Get the last inserted id A. Kretschmer 17:48
Re: Get the last inserted id Andrew Sullivan 17:57

April 14, 2008

Thread Author Time
export CSV file through Java JDBC Emi Lu 13:41
rule for update view that updates/inserts into 2 tables Chad Showalter 16:47

April 15, 2008

Thread Author Time
Re: rule for update view that updates/inserts into 2 tables Robins Tharakan 00:33
Re: rule for update view that updates/inserts into 2 tables Chad Showalter 15:27
Re: [SQL] rule for update view that updates/inserts into 2 tables Martijn van Oosterhout 15:41
Re: export CSV file through Java JDBC Steve Midgley 17:13

April 16, 2008

Thread Author Time
How to find double entries Andreas 03:15
Re: How to find double entries Tom Lane 03:23
Re: How to find double entries Craig Ringer 04:22
Re: How to find double entries Tena Sakai 05:05
Re: How to find double entries Volkan YAZICI 06:15
Multiple databases Sumaya 06:59
Re: Multiple databases A. Kretschmer 07:24
Index on elements of an array Florian Weimer 08:49
Re: Multiple databases Gerardo Herzig 12:01
Data Comparison Single Table Question Bryan Emrys 13:34
Re: How to find double entries Vivek Khera 14:27
Re: Data Comparison Single Table Question Osvaldo Rosario Kussama 15:09
Re: How to find double entries Craig Ringer 15:49
SQL/XML Multi table join question Mina R Waheeb 18:34
using string functions on plpgsql Marcelo Edgardo Paniagua Lizarraga 21:50

April 17, 2008

Thread Author Time
Re: using string functions on plpgsql Tom Lane 00:08
Re: using string functions on plpgsql Craig Ringer 01:47
Re: using string functions on plpgsql Craig Ringer 01:51
What does mod - in "mod statement" - stand for? Daniel CAUNE 03:01
Re: What does mod - in "mod statement" - stand for? Craig Ringer 04:27
Re: using string functions on plpgsql Tom Lane 04:42
error codes Marcin Krawczyk 08:23
Desc Commnad in pgsql? VG 08:47
Re: Desc Commnad in pgsql? A. Kretschmer 08:53
Re: Desc Commnad in pgsql? Richard Huxton 08:59
Error in restore the Database in Postgres dipesh 10:38
Re: error codes Craig Ringer 10:43
Re: error codes Craig Ringer 10:51
Re: Error in restore the Database in Postgres Richard Huxton 11:01

Browse Archives

Prev | Next