pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
getting ILIKE or  ~*  to use indexes....
  2002-08-10 06:13 UTC  Rajesh Kumar Mallah. <mallah@trade-india.com>
` Re: getting ILIKE or  ~*  to use indexes....
  2002-08-10 18:10 UTC  Josh Berkus <josh@agliodbs.com>
` Re: getting ILIKE or  ~*  to use indexes....
  2002-08-10 21:14 UTC  mallah@trade-india.com
  [3+ messages in thread]

retrieving all rows from a "tree" in one select - how ?
  2002-08-09 21:36 UTC  h012@ied.com
` Re: retrieving all rows from a "tree" in one select - how ?
  2002-08-09 22:04 UTC  Adam Erickson <adamre@cox.net>
` Re: retrieving all rows from a "tree" in one select - how ?
  2002-08-09 22:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: retrieving all rows from a "tree" in one select - how ?
  2002-08-09 23:37 UTC  Oleg Bartunov <oleg@sai.msu.su>
  [4+ messages in thread]

How to update record in a specified order
  2002-08-09 21:21 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: How to update record in a specified order
  2002-08-09 21:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: How to update record in a specified order
  2002-08-09 21:59 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: How to update record in a specified order
  2002-08-09 22:02 UTC  Dan Langille <dan@langille.org>
` Re: How to update record in a specified order
  2002-08-09 22:12 UTC  Josh Berkus <josh@agliodbs.com>
  [5+ messages in thread]

RE: SQL Syntax
  1999-02-08 20:49 UTC  Jackson, DeJuan <djackson@cpsgroup.com>
` SQL syntax
  2002-07-31 13:16 UTC  Mindaugas Riauba <mind@bi.lt>
` Re: SQL syntax
  2002-07-31 15:57 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` SQL syntax
  2002-08-06 15:29 UTC  frederic massot <frederic@juliana-multimedia.com>
` Re: SQL syntax
  2002-08-06 16:48 UTC  Tod McQuillin <devin@spamcop.net>
` Re: SQL syntax
  2002-08-06 17:10 UTC  Cedric Dufour (Cogito Ergo Soft) <cedric.dufour@cogito-ergo-soft.com>
` Re: SQL syntax
  2002-08-06 17:38 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: SQL syntax
  2002-08-06 17:53 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: SQL syntax
  2002-08-07 03:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL syntax
  2002-08-07 03:47 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: SQL syntax
  2002-08-09 21:36 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
  [11+ messages in thread]

expressions operating on arrays
  2002-08-09 04:38 UTC  h012@ied.com
` Re: expressions operating on arrays
  2002-08-09 06:17 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: expressions operating on arrays
  2002-08-09 07:12 UTC  h012@ied.com
` Re: expressions operating on arrays
  2002-08-09 07:30 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: expressions operating on arrays
  2002-08-09 13:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: expressions operating on arrays
  2002-08-09 14:57 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: expressions operating on arrays
  2002-08-09 20:49 UTC  h012@ied.com
  [7+ messages in thread]

Table Sorting and Limit Question
  2002-08-08 20:10 UTC  Dawn Hollingsworth <dmh@airdefense.net>
` Re: Table Sorting and Limit Question
  2002-08-09 01:42 UTC  Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: Table Sorting and Limit Question
  2002-08-09 13:55 UTC  Dawn Hollingsworth <dmh@airdefense.net>
  [3+ messages in thread]

getting oid of an INSERT automatically
  2002-08-07 18:39 UTC  John Brothers <johnbr@undefined.com>
` Re: getting oid of an INSERT automatically
  2002-08-08 13:28 UTC  Oliver Elphick <olly@lfix.co.uk>
` Re: getting oid of an INSERT automatically
  2002-08-08 19:18 UTC  John Brothers <johnbr@undefined.com>
  [3+ messages in thread]

looking to speed up SELECT ... LEFT JOIN query
  2002-08-07 05:03 UTC  Trey Ackerman <ta145@yahoo.com>
` Re: looking to speed up SELECT ... LEFT JOIN query
  2002-08-08 14:24 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

manipulating the POINT data type
  2002-08-07 17:16 UTC  Floyd Shackelford <floyds@4peakstech.com>
` Re: manipulating the POINT data type
  2002-08-08 13:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

to_char and '=' weirdness
  2002-08-08 11:33 UTC  Frank Joerdens <frank@joerdens.de>
` Re: to_char and '=' weirdness
  2002-08-08 11:48 UTC  Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: to_char and '=' weirdness
  2002-08-08 12:11 UTC  Karel Zak <zakkr@zf.jcu.cz>
` Re: to_char and '=' weirdness
  2002-08-08 12:46 UTC  Frank Joerdens <frank@joerdens.de>
` Re: to_char and '=' weirdness
  2002-08-08 13:04 UTC  Frank Joerdens <frank@joerdens.de>
  [5+ messages in thread]

Altering live databases
  2002-08-07 21:45 UTC  Gregory Brauer <greg@wildbrain.com>
` Re: Altering live databases
  2002-08-08 02:38 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Altering live databases
  2002-08-08 02:52 UTC  Gregory Brauer <greg@wildbrain.com>
` Re: Altering live databases
  2002-08-08 02:59 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [4+ messages in thread]

ALTER TABLE follow up
  2002-08-06 22:41 UTC  Tom Haddon <tom@betterhealthfoundation.org>
` Re: ALTER TABLE follow up
  2002-08-07 02:02 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: ALTER TABLE follow up
  2002-08-07 18:30 UTC  Tom Haddon <tom@betterhealthfoundation.org>
` Re: ALTER TABLE follow up
  2002-08-08 02:32 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [4+ messages in thread]

running psql in a cron job
  2002-08-07 14:51 UTC  Wei Weng <wweng@kencast.com>
` Re: running psql in a cron job
  2002-08-07 15:01 UTC  Wei Weng <wweng@kencast.com>
` Re: running psql in a cron job
  2002-08-07 17:07 UTC  Wei Weng <wweng@kencast.com>
` Re: running psql in a cron job
  2002-08-07 18:02 UTC  Ignacio Coloma <icoloma-lists@iverdino.com>
` Re: running psql in a cron job
  2002-08-07 18:54 UTC  Ross J. Reedstrom <reedstrm@rice.edu>
  [5+ messages in thread]

Table is modified?
  2002-08-07 14:29 UTC  Yuri Gordienko <iqsoft@cg.ukrtel.net>

control reaches end of trigger procedure without RETURN
  2002-08-06 22:12 UTC  rramostalo@quorum.com
` Re: control reaches end of trigger procedure without RETURN
  2002-08-07 13:35 UTC  Jeff Eckermann <jeff_eckermann@yahoo.com>
  [2+ messages in thread]

Views/queries and optimal indexes usage (cf. planner)
  2002-08-07 11:49 UTC  Cédric Dufour <cedric.dufour@freesurf.ch>

Limit A Table To 1 Row
  2002-08-07 03:29 UTC  cnliou@eurosport.com
` Re: Limit A Table To 1 Row
  2002-08-07 03:42 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Limit A Table To 1 Row
  2002-08-07 03:52 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Limit A Table To 1 Row
  2002-08-07 08:30 UTC  Richard Huxton <dev@archonet.com>
  [4+ messages in thread]

problem fetching currval of sequence
  2002-08-06 15:14 UTC  Charles Hauser <chauser@duke.edu>
` Re: problem fetching currval of sequence
  2002-08-06 15:45 UTC  Josh Berkus <josh@agliodbs.com>
` Re: problem fetching currval of sequence
  2002-08-06 15:57 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: problem fetching currval of sequence
  2002-08-06 16:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem fetching currval of sequence
  2002-08-06 16:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem fetching currval of sequence
  2002-08-06 16:43 UTC  Charles Hauser <chauser@duke.edu>
` Re: problem fetching currval of sequence
  2002-08-06 16:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem fetching currval of sequence
  2002-08-06 18:35 UTC  Josh Berkus <josh@agliodbs.com>
` Re: problem fetching currval of sequence
  2002-08-06 20:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem fetching currval of sequence
  2002-08-06 20:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: problem fetching currval of sequence
  2002-08-06 20:53 UTC  Charles Hauser <chauser@duke.edu>
` Re: problem fetching currval of sequence
  2002-08-06 21:26 UTC  Josh Berkus <josh@agliodbs.com>
  [12+ messages in thread]

Multi table insert and passing sequence ids
  2002-08-06 12:55 UTC  Norman Khine <norman@spot5.com>
` Re: Multi table insert and passing sequence ids
  2002-08-06 17:38 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

Transitive Closure
  2002-07-31 04:50 UTC  Suhas Joshi <suhas@hotmail.com>
` Re: Transitive Closure
  2002-08-06 14:06 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Transitive Closure
  2002-08-06 14:59 UTC  Dan Langille <dan@langille.org>
` Re: Transitive Closure
  2002-08-06 15:28 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Transitive Closure
  2002-08-06 17:01 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Transitive Closure
  2002-08-06 17:34 UTC  Oleg Bartunov <oleg@sai.msu.su>
  [6+ messages in thread]

Re: copy files to postgresql
  2002-08-06 12:14 UTC  John Zhang <jzhang@jimmy.harvard.edu>
` Re: copy files to postgresql
  2002-08-06 13:23 UTC  Jeff Eckermann <jeff_eckermann@yahoo.com>
` Re: copy files to postgresql
  2002-08-06 14:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: copy files to postgresql
  2002-08-06 16:20 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
  [4+ messages in thread]

Concatenate aggregate?
  2002-08-06 08:03 UTC  Julian Scarfe <julian.scarfe@ntlworld.com>
` Re: Concatenate aggregate?
  2002-08-06 08:28 UTC  Archibald Zimonyi <archie@netg.se>
` Re: Concatenate aggregate?
  2002-08-06 08:37 UTC  Julian Scarfe <julian.scarfe@ntlworld.com>
  [3+ messages in thread]

VACUUM not doing its job?
  2002-08-03 20:53 UTC  Kristian Eide <kreide@online.no>
` Re: VACUUM not doing its job?
  2002-08-03 22:14 UTC  Ken Corey <ken@kencorey.com>
` Re: VACUUM not doing its job?
  2002-08-03 22:40 UTC  Kristian Eide <kreide@online.no>
` Re: VACUUM not doing its job?
  2002-08-03 22:59 UTC  Sander Steffann <sander@steffann.nl>
` Re: VACUUM not doing its job?
  2002-08-03 23:02 UTC  Joe Conway <mail@joeconway.com>
` Re: VACUUM not doing its job?
  2002-08-03 23:39 UTC  Kristian Eide <kreide@online.no>
` Re: VACUUM not doing its job?
  2002-08-04 00:32 UTC  Joe Conway <mail@joeconway.com>
` Re: VACUUM not doing its job?
  2002-08-04 11:22 UTC  Jochem van Dieten <nomail@devnull.invalid>
` Re: VACUUM not doing its job?
  2002-08-05 21:40 UTC  Robert Treat <xzilla@users.sourceforge.net>
  [9+ messages in thread]

Group And Sort After Union
  2002-07-30 08:46 UTC  cnliou <cnliou@eurosport.com>
` Re: Group And Sort After Union
  2002-08-02 13:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Group And Sort After Union
  2002-08-05 09:55 UTC  Terry Yapt <yapt@technovell.com>
  [3+ messages in thread]

Bug with dump/restore when using UNION and ORDER BY in views
  2002-08-03 21:11 UTC  Kristian Eide <kreide@online.no>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
  2002-08-04 03:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
  2002-08-04 05:24 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
  2002-08-04 05:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
  2002-08-04 05:54 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
  2002-08-04 06:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ 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