pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SQL standards in Mysql
  2008-02-22 18:57 UTC  Ken Johanson <pg-user@kensystem.com>
` Re: SQL standards in Mysql
  2008-02-22 19:57 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: SQL standards in Mysql
  2008-02-23 00:13 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: SQL standards in Mysql
  2008-02-23 01:39 UTC  Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
` Re: SQL standards in Mysql
  2008-02-23 05:03 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: SQL standards in Mysql
  2008-02-23 05:34 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: SQL standards in Mysql
  2008-02-23 05:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL standards in Mysql
  2008-02-23 21:06 UTC  Aarni Ruuhimäki <aarni@kymi.com>
` Re: SQL standards in Mysql
  2008-02-27 18:31 UTC  Steve Crawford <scrawford@pinpointresearch.com>
  [9+ messages in thread]

how do I get table DDL from psql (not from pg_dump)
  2008-02-27 11:22 UTC  Sofer, Yuval <Yuval_Sofer@bmc.com>
` Re: how do I get table DDL from psql (not from pg_dump)
  2008-02-27 12:19 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: how do I get table DDL from psql (not from pg_dump)
  2008-02-27 15:23 UTC  Frank Bax <fbax@sympatico.ca>
` Re: how do I get table DDL from psql (not from pg_dump)
  2008-02-27 16:57 UTC  Lew <lew@lwsc.ehost-services.com>
  [4+ messages in thread]

REFERENCES and INHERITS restrictions?
  2008-02-27 09:25 UTC  Stefan Scheidegger <Stefan.Scheidegger@gmx.net>
` Re: REFERENCES and INHERITS restrictions?
  2008-02-27 14:04 UTC  Gregory Stark <stark@enterprisedb.com>
  [2+ messages in thread]

Re: duplicate key violates unique constraint
  2005-06-13 14:43 UTC  Richard Huxton <dev@archonet.com>
` Re: duplicate key violates unique constraint
  2005-06-13 14:45 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: duplicate key violates unique constraint
  2005-06-13 15:22 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: duplicate key violates unique constraint
  2005-06-13 15:49 UTC  Richard Huxton <dev@archonet.com>
` Re: duplicate key violates unique constraint
  2005-06-13 15:58 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: duplicate key violates unique constraint
  2005-06-13 16:03 UTC  Richard Huxton <dev@archonet.com>
` duplicate key violates unique constraint
  2005-06-13 16:22 UTC  ON.KG <skyer@on.kg>
` duplicate key violates unique constraint
  2008-02-26 14:55 UTC  Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
` Re: duplicate key violates unique constraint
  2008-02-26 15:17 UTC  Teemu Torma <teemu@torma.org>
` Re: duplicate key violates unique constraint
  2008-02-26 16:05 UTC  Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
` Re: duplicate key violates unique constraint
  2008-02-26 16:22 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: duplicate key violates unique constraint
  2008-02-26 16:28 UTC  Teemu Torma <teemu@torma.org>
` Re: duplicate key violates unique constraint
  2008-02-26 16:34 UTC  Bart Degryse <Bart.Degryse@indicator.be>
` Re: duplicate key violates unique constraint
  2008-02-26 16:36 UTC  Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
` Re: duplicate key violates unique constraint
  2008-02-26 17:03 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: duplicate key violates unique constraint
  2008-02-26 17:09 UTC  Rodrigo E. De León Plicet <rdeleonp@gmail.com>
` Re: duplicate key violates unique constraint
  2008-02-26 19:29 UTC  Edward W. Rouse <erouse@comsquared.com>
  [17+ messages in thread]

Re: Deploying PostgreSQL on virtualized hardware
  2008-02-26 14:56 UTC  TJ O'Donnell <tjo@acm.org>
` Re: [SQL] Deploying PostgreSQL on virtualized hardware
  2008-02-26 17:33 UTC  Colin Wetherbee <cww@denterprises.org>
  [2+ messages in thread]

Bounce test
  2008-02-26 03:13 UTC  Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
` Re: Bounce test
  2008-02-26 03:17 UTC  Adrian Klaver <aklaver@comcast.net>
` Re: Bounce test
  2008-02-26 03:20 UTC  Adrian Klaver <aklaver@comcast.net>
` Re: Bounce test
  2008-02-26 03:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bounce test
  2008-02-26 03:28 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Bounce test
  2008-02-26 03:29 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Bounce test
  2008-02-26 03:32 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Bounce test
  2008-02-26 03:36 UTC  Colin Wetherbee <cww@denterprises.org>
` Re: Bounce test
  2008-02-26 03:54 UTC  Adrian Klaver <aklaver@comcast.net>
` Re: Bounce test
  2008-02-26 04:07 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Bounce test
  2008-02-26 05:08 UTC  Adrian Klaver <aklaver@comcast.net>
  [11+ messages in thread]

postgresql function not accepting null values in select statement
  2008-02-22 08:30 UTC  Jyoti Seth <jyotiseth2001@gmail.com>
` Re: postgresql function not accepting null values in select statement
  2008-02-22 09:05 UTC  Richard Huxton <dev@archonet.com>
` Re: postgresql function not accepting null values in select statement
  2008-02-22 09:22 UTC  Jyoti Seth <jyotiseth2001@gmail.com>
` Re: postgresql function not accepting null values in select statement
  2008-02-22 09:33 UTC  Richard Huxton <dev@archonet.com>
` Re: postgresql function not accepting null values in select statement
  2008-02-22 09:34 UTC  Robins Tharakan <tharakan@gmail.com>
` Re: postgresql function not accepting null values inselect  statement
  2008-02-22 09:35 UTC  Bart Degryse <Bart.Degryse@indicator.be>
` Re: postgresql function not accepting null values inselect statement
  2008-02-22 16:30 UTC  johnf <jfabiani@yolo.com>
` Re: postgresql function not accepting null values inselect statement
  2008-02-25 05:20 UTC  Jyoti Seth <jyotiseth2001@gmail.com>
` Re: postgresql function not accepting null values inselect statement
  2008-02-25 06:56 UTC  Robins Tharakan <tharakan@gmail.com>
` Re: postgresql function not accepting null values inselect statement
  2008-02-25 07:03 UTC  Robins Tharakan <tharakan@gmail.com>
` Re: postgresql function not accepting null valuesinselect statement
  2008-02-25 08:05 UTC  Bart Degryse <Bart.Degryse@indicator.be>
  [11+ messages in thread]

autovacuum not freeing up unused space on 8.3.0
  2008-02-25 06:27 UTC  Stuart Brooks <stuartb@cat.co.za>
` Re: autovacuum not freeing up unused space on 8.3.0
  2008-02-25 06:57 UTC  Stuart Brooks <stuartb@cat.co.za>
  [2+ messages in thread]

Delete with foreign keys
  2008-02-22 18:00 UTC  felix@crowfix.com
` Re: Delete with foreign keys
  2008-02-23 07:12 UTC  dipesh <dipesh.mistry@mobilefundas.com>
` Re: Delete with foreign keys
  2008-02-23 07:47 UTC  felix@crowfix.com
  [3+ messages in thread]

Proposed archival read only trigger on rows - prevent history modification
  2008-01-29 04:16 UTC  Bryce Nesbitt <bryce1@obviously.com>
` Re: Proposed archival read only trigger on rows - prevent history modification
  2008-01-29 04:40 UTC  chester c young <chestercyoung@yahoo.com>
` Re: Proposed archival read only trigger on rows - prevent history modification
  2008-01-30 04:31 UTC  Steve Midgley <public@misuse.org>
` Re: Proposed archival read only trigger on rows - prevent history modification
  2008-02-12 08:25 UTC  Bryce Nesbitt <bryce1@obviously.com>
` Re: Proposed archival read only trigger on rows - prevent history modification
  2008-02-12 08:30 UTC  Bryce Nesbitt <bryce1@obviously.com>
` Re: Proposed archival read only trigger on rows - prevent history modification
  2008-02-22 03:31 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Proposed archival read only trigger on rows - prevent history modification
  2008-02-22 04:09 UTC  Phillip Smith <phillip.smith@weatherbeeta.com.au>
  [7+ messages in thread]

Data layer migration from MSSQL
  2008-02-21 17:47 UTC  Sebastian Rychter <srychter@anvet.com.ar>
` Re: Data layer migration from MSSQL
  2008-02-21 18:42 UTC  Medi Montaseri <montaseri@gmail.com>
` Re: Data layer migration from MSSQL
  2008-02-21 18:55 UTC  Sebastian Rychter <srychter@anvet.com.ar>
  [3+ messages in thread]

Am I wasting my time with partitions?
  2008-02-19 10:54 UTC  Stuart Brooks <stuartb@cat.co.za>
` Re: Am I wasting my time with partitions?
  2008-02-19 13:48 UTC  Richard Huxton <dev@archonet.com>
` Re: Am I wasting my time with partitions?
  2008-02-19 14:05 UTC  Stuart Brooks <stuartb@cat.co.za>
  [3+ messages in thread]

SELECT DISTINCT
  1999-01-02 01:34 UTC  Tim Perdue, The Des Moines City.net <tim@dmcity.net>
` Re: [SQL] SELECT DISTINCT
  1999-01-02 02:40 UTC  Peter Garner <peter_garner@yahoo.com>
` Re: [SQL] SELECT DISTINCT
  1999-01-02 03:15 UTC  Tim Perdue, The Des Moines City.net <tim@dmcity.net>
` select distinct?
  1999-12-08 01:03 UTC  Chris Griffin <cgriffin@websales.com>
` Re: [SQL] select distinct?
  1999-12-08 01:58 UTC  Chris Griffin <cgriffin@websales.com>
` SELECT DISTINCT
  2008-02-19 10:01 UTC  Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
` Re: SELECT DISTINCT
  2008-02-19 13:51 UTC  Richard Huxton <dev@archonet.com>
  [7+ messages in thread]

UPDATE WITH ORDER BY
  2005-04-26 03:12 UTC  Rodrigo Carvalhaes <grupos@carvalhaes.net>
` Re: UPDATE WITH ORDER BY
  2005-04-26 06:58 UTC  Ramakrishnan Muralidharan <ramakrishnanm@pervasive-postgres.com>
` Re: UPDATE WITH ORDER BY
  2005-04-26 09:08 UTC  Christoph Haller <ch@rodos.fzk.de>
` Re: UPDATE WITH ORDER BY
  2005-04-26 16:07 UTC  Rodrigo Carvalhaes <grupos@carvalhaes.net>
` Re: UPDATE WITH ORDER BY
  2005-04-27 12:05 UTC  Greg Sabino Mullane <greg@turnstep.com>
` UPDATE with ORDER BY
  2008-02-19 12:49 UTC  Robins Tharakan <tharakan@gmail.com>
  [6+ messages in thread]

comment on COLUMN, broken or misunderstanding?
  2008-02-18 02:18 UTC  Bryce Nesbitt <bryce1@obviously.com>
` Re: comment on COLUMN, broken or misunderstanding?
  2008-02-18 02:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: comment on COLUMN, broken or misunderstanding?
  2008-02-18 02:39 UTC  Markus Bertheau <mbertheau.pg@googlemail.com>
` Re: comment on COLUMN, broken or misunderstanding?
  2008-02-18 02:50 UTC  Milen A. Radev <milen@radev.net>
` Re: comment on COLUMN, broken or misunderstanding?
  2008-02-18 04:38 UTC  Michael Fuhr <mike@fuhr.org>
  [5+ messages in thread]

Backward compatibility psql  8.1 to 8.2
  2008-02-12 08:22 UTC  Bryce Nesbitt <bryce1@obviously.com>
` Re: Backward compatibility psql  8.1 to 8.2
  2008-02-12 08:32 UTC  Richard Huxton <dev@archonet.com>
` Re: Backward compatibility psql  8.1 to 8.2
  2008-02-16 04:32 UTC  Bryce Nesbitt <bryce1@obviously.com>
` Re: Backward compatibility psql 8.1 to 8.2
  2008-02-16 05:22 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Backward compatibility psql 8.1 to 8.2
  2008-02-17 15:23 UTC  Peter Eisentraut <peter_e@gmx.net>
  [5+ messages in thread]

PostgreSQL does not support updateable cursors
  2008-02-12 06:33 UTC  Premsun Choltanwanich <Premsun@nsasia.co.th>
` Re: PostgreSQL does not support updateable cursors
  2008-02-17 15:21 UTC  Peter Eisentraut <peter_e@gmx.net>
  [2+ messages in thread]

Usage of UUID with 8.3 (Windows)
  2008-02-11 10:25 UTC  ncode@gmx.com
` Re: Usage of UUID with 8.3 (Windows)
  2008-02-11 16:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Usage of UUID with 8.3 (Windows)
  2008-02-11 17:04 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Usage of UUID with 8.3 (Windows)
  2008-02-11 17:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Usage of UUID with 8.3 (Windows)
  2008-02-12 09:05 UTC  Sven Sporer <ncode@gmx.com>
` Re: Usage of UUID with 8.3 (Windows)
  2008-02-12 18:11 UTC  Steve Midgley <public@misuse.org>
` Re: Usage of UUID with 8.3 (Windows)
  2008-02-17 15:20 UTC  Peter Eisentraut <peter_e@gmx.net>
  [7+ messages in thread]

FUNCTIONs and CASTs
  2008-02-14 23:08 UTC  Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
` Re: FUNCTIONs and CASTs
  2008-02-14 23:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: FUNCTIONs and CASTs
  2008-02-15 01:47 UTC  Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
` Re: FUNCTIONs and CASTs
  2008-02-15 09:38 UTC  Richard Huxton <dev@archonet.com>
` Re: FUNCTIONs and CASTs
  2008-02-15 18:18 UTC  Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
` Re: FUNCTIONs and CASTs
  2008-02-15 22:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: FUNCTIONs and CASTs
  2008-02-15 23:03 UTC  Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
` Re: FUNCTIONs and CASTs
  2008-02-16 00:45 UTC  Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
  [8+ messages in thread]

String function   to  Find how many times str2 is in str1?
  2008-02-15 16:09 UTC  Emi Lu <emilu@encs.concordia.ca>
` Re: String function to Find how many times str2 is in str1?
  2008-02-15 17:46 UTC  Rodrigo E. De León Plicet <rdeleonp@gmail.com>
` Re: String function to Find how many times str2 is in str1?
  2008-02-15 18:23 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: String function to Find how many times str2 is in str1?
  2008-02-15 18:28 UTC  Emi Lu <emilu@encs.concordia.ca>
  [4+ messages in thread]

Re:
  2001-09-09 03:12 UTC  postgresql <pgsql@symcom.com>
` Function description
  2008-02-15 08:50 UTC  Bart Degryse <Bart.Degryse@indicator.be>
` Re: Function description
  2008-02-15 09:09 UTC  Richard Huxton <dev@archonet.com>
` Re: Function description
  2008-02-15 10:15 UTC  Richard Huxton <dev@archonet.com>
` Re: Function description
  2008-02-15 10:37 UTC  Bart Degryse <Bart.Degryse@indicator.be>
` Re: Function description
  2008-02-15 10:50 UTC  Richard Huxton <dev@archonet.com>
` Re: Function description
  2008-02-15 11:05 UTC  Bart Degryse <Bart.Degryse@indicator.be>
` Re: Function description
  2008-02-15 11:17 UTC  Richard Huxton <dev@archonet.com>
` Re: Function description
  2008-02-15 11:46 UTC  Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>
` Re: Function description
  2008-02-15 12:18 UTC  Bart Degryse <Bart.Degryse@indicator.be>
` Re: Function description
  2008-02-15 12:21 UTC  Bart Degryse <Bart.Degryse@indicator.be>
` Re: Function description
  2008-02-15 12:33 UTC  Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>
` Re: Function description
  2008-02-15 13:00 UTC  Bart Degryse <Bart.Degryse@indicator.be>
  [13+ messages in thread]

Packages
  2008-02-15 11:46 UTC  Jyoti Seth <jyotiseth2001@gmail.com>
` Re: Packages
  2008-02-15 12:16 UTC  Bart Degryse <Bart.Degryse@indicator.be>
  [2+ messages in thread]

inhibit rounding on numeric columns
  2008-02-15 07:28 UTC  Horst Dehmer <horst.dehmer@inode.at>
` Re: inhibit rounding on numeric columns
  2008-02-15 07:42 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: inhibit rounding on numeric columns
  2008-02-15 07:46 UTC  Niklas Johansson <spot@tele2.se>
` Re: inhibit rounding on numeric columns
  2008-02-15 07:53 UTC  Bart Degryse <Bart.Degryse@indicator.be>
  [4+ messages in thread]

PL/pgsql question
  2001-06-12 13:59 UTC  Andrea Suisani <suisani@demetra.com>
` PL/pgSQL question
  2002-03-15 23:41 UTC  Dmitry Tkach <dmitry@openratings.com>
` Pl/pgSQL Question.
  2002-04-25 04:34 UTC  Bruno Ricardo Sacco <bsacco@hypernet.com.py>
` Pl/pgSQL Question.
  2002-04-25 04:44 UTC  Bruno Ricardo Sacco <bsacco@hypernet.com.py>
` pl/pgsql question
  2002-12-18 04:12 UTC  Tim Perdue <tim@perdue.net>
` Re: pl/pgsql question
  2002-12-18 04:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pl/pgsql question
  2002-12-18 04:29 UTC  Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: pl/pgsql question
  2002-12-18 14:02 UTC  Tim Perdue <tim@perdue.net>
` Re: pl/pgsql question
  2002-12-18 16:30 UTC  Josh Berkus <josh@agliodbs.com>
` Re: pl/pgsql question
  2002-12-18 16:44 UTC  Tim Perdue <tim@perdue.net>
` Re: PL/pgSQL question
  2003-02-02 21:59 UTC  Josh Berkus <josh@agliodbs.com>
` PL/PgSQL Question
  2003-04-25 15:52 UTC  Brian Knox <laotse@aol.net>
` Re: PL/PgSQL Question
  2003-04-26 08:53 UTC  A.Bhuvaneswaran <bhuvansql@myrealbox.com>
` PL/pgSQL question
  2008-02-14 13:23 UTC  Sebastian Ritter <ritter.sebastian@gmail.com>
` Re: PL/pgSQL question
  2008-02-14 13:50 UTC  Milen A. Radev <milen@radev.net>
  [15+ messages in thread]

return field from different table conditionally
  2008-02-13 10:54 UTC  Bart Degryse <Bart.Degryse@indicator.be>
` Re: return field from different table conditionally
  2008-02-13 17:16 UTC  Bart Degryse <Bart.Degryse@indicator.be>
  [2+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox