pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can I do this?
  2003-01-17 23:51 UTC  Wei Weng <wweng@kencast.com>
` Re: Can I do this?
  2003-01-18 00:19 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Can I do this?
  2003-01-18 00:31 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

double precision to numeric overflow error
  2003-01-07 23:12 UTC  Thomas O'Connell <tfo@monsterlabs.com>
` Re: [SQL] double precision to numeric overflow error
  2003-01-07 23:36 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: double precision to numeric overflow error
  2003-01-08 03:01 UTC  Thomas O'Connell <tfo@monsterlabs.com>
` Re: double precision to numeric overflow error
  2003-01-08 04:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: double precision to numeric overflow error
  2003-01-08 05:36 UTC  Thomas O'Connell <tfo@monsterlabs.com>
` Re: double precision to numeric overflow error
  2003-01-17 20:43 UTC  Jan Wieck <JanWieck@Yahoo.com>
  [6+ messages in thread]

"Best practice" advice
  2003-01-17 20:06 UTC  Andrew Perrin <clists@perrin.socsci.unc.edu>
` Re: "Best practice" advice
  2003-01-17 20:16 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

RCF: 2nd draft: A brief guide to Nulls
  2003-01-17 15:05 UTC  dev@archonet.com

query speed joining tables
  2003-01-13 21:20 UTC  Christopher Smith <christopherl_smith@yahoo.com>
` Re: query speed joining tables
  2003-01-13 21:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: query speed joining tables
  2003-01-13 21:56 UTC  Christopher Smith <christopherl_smith@yahoo.com>
` Re: query speed joining tables
  2003-01-13 22:01 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: query speed joining tables
  2003-01-13 22:03 UTC  Christopher Smith <christopherl_smith@yahoo.com>
` Re: query speed joining tables
  2003-01-14 07:12 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: query speed joining tables
  2003-01-14 19:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: query speed joining tables
  2003-01-15 17:50 UTC  Josh Berkus <josh@agliodbs.com>
` Re: query speed joining tables
  2003-01-15 18:33 UTC  Vernon Wu <vernonw@gatewaytech.com>
` Re: query speed joining tables
  2003-01-16 17:46 UTC  Josh Berkus <josh@agliodbs.com>
` Re: query speed joining tables
  2003-01-16 23:22 UTC  Vernon Wu <vernonw@gatewaytech.com>
` Re: query speed joining tables
  2003-01-16 23:42 UTC  Josh Berkus <josh@agliodbs.com>
  [12+ messages in thread]

pg_restore cannot restore an index
  2003-01-16 17:39 UTC  Jie Liang <jie@stbernard.com>
` Re: pg_restore cannot restore an index
  2003-01-16 18:07 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: pg_restore cannot restore an index
  2003-01-16 18:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_restore cannot restore an index
  2003-01-16 22:21 UTC  Jie Liang <jie@stbernard.com>
  [4+ messages in thread]

Re: RFC: A brief guide to nulls
  2003-01-14 19:46 UTC  Josh Berkus <josh@agliodbs.com>
` RFC: A brief guide to nulls
  2003-01-15 17:23 UTC  dev@archonet.com
` Re: RFC: A brief guide to nulls
  2003-01-15 19:18 UTC  Andrew Perrin <clists@perrin.socsci.unc.edu>
` Re: RFC: A brief guide to nulls
  2003-01-15 19:51 UTC  Antti Haapala <antti.haapala@iki.fi>
` Re: RFC: A brief guide to nulls
  2003-01-15 20:41 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: RFC: A brief guide to nulls
  2003-01-15 22:19 UTC  Antti Haapala <antti.haapala@iki.fi>
` Re: RFC: A brief guide to nulls
  2003-01-15 23:44 UTC  Peter Eisentraut <peter_e@gmx.net>
` Re: RFC: A brief guide to nulls
  2003-01-16 01:59 UTC  Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: RFC: A brief guide to nulls
  2003-01-16 04:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: RFC: A brief guide to nulls
  2003-01-16 09:07 UTC  dev@archonet.com
` Re: RFC: A brief guide to nulls
  2003-01-16 09:09 UTC  dev@archonet.com
` Re: RFC: A brief guide to nulls
  2003-01-16 17:22 UTC  Otto Hirr <otto.hirr@olabinc.com>
  [12+ messages in thread]

Oracle outer join porting question
  2003-01-15 14:31 UTC  Marko Asplund <aspa@kronodoc.fi>
` Re: Oracle outer join porting question
  2003-01-15 14:38 UTC  Dan Langille <dan@langille.org>
` Re: Oracle outer join porting question
  2003-01-15 14:40 UTC  Tambet Matiisen <t.matiisen@aprote.ee>
` Re: Oracle outer join porting question
  2003-01-15 15:01 UTC  Dan Langille <dan@langille.org>
` Re: Oracle outer join porting question
  2003-01-16 11:32 UTC  Marko Asplund <aspa@kronodoc.fi>
  [5+ messages in thread]

Re: RFC: A brief guide to nulls (noarchive)
  2003-01-16 10:01 UTC  Ries van Twisk <ries@jongert.nl>

show data from two tables together
  2003-01-16 01:01 UTC  Matthew Nuzum <cobalt@bearfruit.org>
` Re: show data from two tables together
  2003-01-16 03:26 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: show data from two tables together
  2003-01-16 03:46 UTC  Matthew Nuzum <cobalt@bearfruit.org>
  [3+ messages in thread]

joining from multiple tables
  2003-01-16 01:43 UTC  Joseph Shraibman <jks@selectacast.net>
` Re: joining from multiple tables
  2003-01-16 02:02 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  [2+ messages in thread]

lost on self joins
  2003-01-15 18:29 UTC  Matthew Nuzum <cobalt@bearfruit.org>
` Re: lost on self joins
  2003-01-15 19:59 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: lost on self joins
  2003-01-15 20:19 UTC  Matthew Nuzum <cobalt@bearfruit.org>
` Re: lost on self joins
  2003-01-15 20:52 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: lost on self joins
  2003-01-15 22:54 UTC  Ross J. Reedstrom <reedstrm@rice.edu>
` Re: lost on self joins
  2003-01-16 00:04 UTC  Tomasz Myrta <jasiek@klaster.net>
  [6+ messages in thread]

index on to_char(created, 'YYYY') doesn't work
  2003-01-15 11:37 UTC  Andreas Joseph Krogh <andreak@officenet.no>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 11:52 UTC  Andreas Joseph Krogh <andreak@officenet.no>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 12:08 UTC  Andreas Joseph Krogh <andreak@officenet.no>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 15:04 UTC  Andreas Joseph Krogh <andreak@officenet.no>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 15:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 16:12 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 17:19 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 17:38 UTC  Andreas Joseph Krogh <andreak@officenet.no>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 18:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 18:55 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: index on to_char(created, 'YYYY') doesn't work
  2003-01-15 20:02 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  [11+ messages in thread]

Re: sub-select with aggregate
  2002-10-23 08:44 UTC  Tomasz Myrta <jasiek@klaster.net>
` sub-select with aggregate
  2002-10-23 10:07 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: sub-select with aggregate
  2002-10-23 13:02 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: sub-select with aggregate
  2002-10-23 14:02 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: sub-select with aggregate
  2002-10-23 14:25 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: sub-select with aggregate
  2002-10-23 14:53 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: sub-select with aggregate
  2002-10-23 15:12 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: sub-select with aggregate
  2002-10-23 15:27 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: sub-select with aggregate
  2002-10-23 15:57 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: sub-select with aggregate
  2002-10-23 23:19 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: sub-select with aggregate
  2002-10-24 08:51 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: sub-select with aggregate
  2002-10-24 09:37 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: sub-select with aggregate
  2002-10-24 09:39 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: sub-select with aggregate
  2002-10-24 15:19 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: sub-select with aggregate
  2002-10-24 16:39 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: sub-select with aggregate
  2002-10-24 20:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sub-select with aggregate
  2003-01-15 19:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [17+ messages in thread]

Re: A brief guide to nulls
  2003-01-15 18:30 UTC  Otto Hirr <otto.hirr@olabinc.com>

Performance of request of type WHERE ... IN ( ... )
  2003-01-15 10:23 UTC  Th Templ <templ_th@hotmail.com>
` Re: Performance of request of type WHERE ... IN ( ... )
  2003-01-15 15:00 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: Performance of request of type WHERE ... IN ( ... )
  2003-01-15 17:17 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

full join in view
  2003-01-08 11:14 UTC  Tambet Matiisen <t.matiisen@aprote.ee>
` Re: full join in view
  2003-01-08 13:41 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: full join in view
  2003-01-14 09:04 UTC  Tambet Matiisen <t.matiisen@aprote.ee>
` Re: full join in view
  2003-01-14 09:50 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: full join in view
  2003-01-14 14:27 UTC  Tambet Matiisen <t.matiisen@aprote.ee>
` Re: full join in view
  2003-01-14 20:02 UTC  jasiek@klaster.net
` Re: full join in view
  2003-01-15 09:25 UTC  Tambet Matiisen <t.matiisen@aprote.ee>
  [7+ messages in thread]

Select * from users WHERE upper(lastName) = upper('Pringle')
  2003-01-10 23:45 UTC  Hale Pringle <halepringle@yahoo.com>
` Re: Select * from users WHERE upper(lastName) = upper('Pringle')
  2003-01-12 04:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Select * from users WHERE upper(lastName) = upper('Pringle')
  2003-01-14 16:34 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [3+ messages in thread]

database broken ?
  2003-01-14 14:45 UTC  mdc@keko.com.ar <mdc@keko.com.ar>
` Re: database broken ?
  2003-01-14 15:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Data between different databases
  2003-01-14 10:53 UTC  Pedro Igor <pedroigor@aip.com.br>

assigning values to array elements
  2003-01-13 20:25 UTC  J Greenbaum <jj@bu.edu>
` Re: assigning values to array elements
  2003-01-13 21:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: assigning values to array elements
  2003-01-13 21:11 UTC  J Greenbaum <jj@bu.edu>
` Re: assigning values to array elements
  2003-01-14 00:47 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [4+ messages in thread]

Postgresql Bug List?
  2003-01-09 04:11 UTC  Wei Weng <turbowei@yahoo.com>
` Postgresql Bug List?
  2003-01-09 04:22 UTC  Wei Weng <wweng@kencast.com>
` Re: Postgresql Bug List?
  2003-01-09 04:30 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Postgresql Bug List?
  2003-01-09 14:18 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Postgresql Bug List?
  2003-01-13 22:18 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [5+ messages in thread]

insert rule doesn't see id field
  2003-01-07 14:54 UTC  Ron Peterson <rpeterso@mtholyoke.edu>
` Re: insert rule doesn't see id field
  2003-01-07 14:57 UTC  Ron Peterson <rpeterso@mtholyoke.edu>
` Re: insert rule doesn't see id field
  2003-01-07 16:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert rule doesn't see id field
  2003-01-08 18:13 UTC  Ron Peterson <rpeterso@mtholyoke.edu>
` Re: insert rule doesn't see id field
  2003-01-09 19:12 UTC  Ron Peterson <rpeterso@mtholyoke.edu>
` Re: insert rule doesn't see id field
  2003-01-09 19:54 UTC  dev@archonet.com
` Re: insert rule doesn't see id field
  2003-01-09 21:50 UTC  Ron Peterson <rpeterso@mtholyoke.edu>
` Re: insert rule doesn't see id field
  2003-01-10 02:07 UTC  Ron Peterson <rpeterso@mtholyoke.edu>
` Re: insert rule doesn't see id field
  2003-01-10 04:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert rule doesn't see id field
  2003-01-10 09:31 UTC  Radu-Adrian Popescu <radu.popescu@aldratech.com>
` Re: insert rule doesn't see id field
  2003-01-10 09:33 UTC  Radu-Adrian Popescu <radu.popescu@aldratech.com>
` Re: insert rule doesn't see id field
  2003-01-10 16:27 UTC  Ron Peterson <rpeterso@mtholyoke.edu>
` Re: insert rule doesn't see id field
  2003-01-13 22:11 UTC  Ron Peterson <rpeterso@mtholyoke.edu>
` Re: insert rule doesn't see id field
  2003-01-13 22:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [14+ messages in thread]

PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied.
  2003-01-08 17:43 UTC  Zengfa Gao <zfgao@yahoo.com>
` Re: PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied.
  2003-01-13 20:18 UTC  Chris Travers <chris@travelamericas.com>
  [2+ messages in thread]

Crosstab-style query in pure SQL
  2003-01-13 12:47 UTC  dev@archonet.com
` Re: Crosstab-style query in pure SQL
  2003-01-13 17:26 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Crosstab-style query in pure SQL
  2003-01-13 19:30 UTC  dev@archonet.com
  [3+ 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