pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
writing a function to mimic mysql last_insert_id
  2002-09-11 17:23 UTC  Beth Gatewood <beth@vizxlabs.com>
` Re: writing a function to mimic mysql last_insert_id
  2002-09-11 17:30 UTC  Josh Berkus <josh@agliodbs.com>
` Re: writing a function to mimic mysql last_insert_id
  2002-09-11 17:32 UTC  Ross J. Reedstrom <reedstrm@rice.edu>
` Re: writing a function to mimic mysql last_insert_id
  2002-09-11 17:43 UTC  Beth Gatewood <beth@vizxlabs.com>
` Re: writing a function to mimic mysql last_insert_id
  2002-09-11 17:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: writing a function to mimic mysql last_insert_id
  2002-09-12 02:05 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: writing a function to mimic mysql last_insert_id
  2002-09-12 02:21 UTC  Chris <csmith@squiz.net>
` Re: writing a function to mimic mysql last_insert_id
  2002-09-12 02:37 UTC  Beth Gatewood <beth@vizxlabs.com>
` Re: writing a function to mimic mysql last_insert_id
  2002-09-12 03:07 UTC  Joe Conway <mail@joeconway.com>
  [9+ messages in thread]

Rules and Triggers
  2002-05-16 04:59 UTC  Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: Rules and Triggers
  2002-05-16 15:12 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Rules and Triggers
  2002-05-17 18:19 UTC  Jan Wieck <janwieck@yahoo.com>
` Rules and Triggers
  2002-09-10 18:52 UTC  Michael Paesold <mpaesold@gmx.at>
` Re: Rules and Triggers
  2002-09-10 19:24 UTC  Adam Erickson <adamre@cox.net>
` Re: Rules and Triggers
  2002-09-10 19:45 UTC  Michael Paesold <mpaesold@gmx.at>
` Re: Rules and Triggers
  2002-09-10 23:28 UTC  Ross J. Reedstrom <reedstrm@rice.edu>
` Re: Rules and Triggers
  2002-09-11 07:28 UTC  Michael Paesold <mpaesold@gmx.at>
  [8+ messages in thread]

R-Tree, GiST or B-Tree? I will need it?
  2002-09-11 03:43 UTC  Andres Sommerhoff <asommerh@chilesat.net>

Transaction Newbie
  2002-09-10 02:37 UTC  Michelle Murrain <tech@murrain.net>
` Re: Transaction Newbie
  2002-09-10 02:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Transaction Newbie
  2002-09-10 23:27 UTC  Lee Harr <missive@frontiernet.net>
  [3+ messages in thread]

Year and month comparison
  2002-09-10 20:16 UTC  Del Mistro, Enzo <enzo.delmistro@eds.com>

Changing Column Type
  2002-09-09 16:49 UTC  Peter Atkins <peter.atkins@NXCD.com>
` Re: Changing Column Type
  2002-09-10 19:51 UTC  Kevin Brannen <kevinb@nurseamerica.net>
  [2+ messages in thread]

stored procedures: sybase -> postgreSQL ?
  2002-09-09 18:15 UTC  Charles Hauser <chauser@duke.edu>
` Re: stored procedures: sybase -> postgreSQL ?
  2002-09-09 21:02 UTC  Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
` Re: stored procedures: sybase -> postgreSQL ?
  2002-09-10 14:49 UTC  Ross J. Reedstrom <reedstrm@rice.edu>
  [3+ messages in thread]

pgsql-performance mailing list / newsgroup created
  2002-09-10 03:44 UTC  Marc G. Fournier <scrappy@hub.org>

How the R-Tree index works?.
  2002-09-09 21:51 UTC  Andres Sommerhoff <asommerh@chilesat.net>
` Re: How the R-Tree index works?.
  2002-09-10 03:34 UTC  Markus Gieppner <viking@mgfint.com>
  [2+ messages in thread]

Displaying current queries on the database?
  2002-09-09 17:34 UTC  Sloan Bowman <smileyq@nashlinux.com>
` Re: Displaying current queries on the database?
  2002-09-09 17:52 UTC  mallah@trade-india.com
  [2+ messages in thread]

the best way to get the topest 3 record in every group
  2002-09-09 00:21 UTC  jack <datactrl@tpg.com.au>
` Re: the best way to get the topest 3 record in every group
  2002-09-09 06:34 UTC  dima <_pppp@mail.ru>
` Re: the best way to get the topest 3 record in every group
  2002-09-09 08:08 UTC  jack <datactrl@tpg.com.au>
` Re: the best way to get the topest 3 record in every group
  2002-09-09 09:35 UTC  Viacheslav N Tararin <taras@dekasoft.com.ua>
` Re: the best way to get the topest 3 record in every group
  2002-09-09 11:48 UTC  Viacheslav N Tararin <taras@dekasoft.com.ua>
` Re: the best way to get the topest 3 record in every group
  2002-09-09 12:23 UTC  Viacheslav N Tararin <taras@dekasoft.com.ua>
` Re: the best way to get the topest 3 record in every group
  2002-09-09 16:23 UTC  Masaru Sugawara <rk73@sea.plala.or.jp>
  [7+ messages in thread]

Database joins
  2002-09-09 08:58 UTC  Jay <jayps@addr.com>
` Re: Database joins
  2002-09-09 15:44 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  [2+ messages in thread]

Character translation?
  2002-09-05 22:15 UTC  Linn Kubler <lkubler@ecw2.org>
` Re: Character translation?
  2002-09-09 07:47 UTC  Troy <tjk@tksoft.com>
` Re: Character translation?
  2002-09-09 14:50 UTC  Richard Huxton <dev@archonet.com>
` Re: Character translation?
  2002-09-09 15:37 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  [4+ messages in thread]

Cross tables Like%
  2002-09-09 07:20 UTC  Jason Davis <jasondavis19@hotmail.com>
` Re: Cross tables Like%
  2002-09-09 14:05 UTC  Viacheslav N Tararin <taras@dekasoft.com.ua>
  [2+ messages in thread]

new calculated column
  2002-09-05 16:53 UTC  andres javier garcia garcia <andresjavier.garcia@wanadoo.es>
` new calculated column
  2002-09-05 16:58 UTC  andres javier garcia garcia <andresjavier.garcia@wanadoo.es>
` Re: new calculated column
  2002-09-05 18:49 UTC  mallah@trade-india.com
` Re: new calculated column
  2002-09-09 14:01 UTC  Viacheslav N Tararin <taras@dekasoft.com.ua>
  [4+ messages in thread]

Efficiency Question
  2002-09-09 00:13 UTC  Colin Fox <cfox@cfconsulting.ca>
` Re: Efficiency Question
  2002-09-09 13:57 UTC  Bruno Wolff III <bruno@wolff.to>
  [2+ messages in thread]

Hardware performance for large updates
  2002-09-06 00:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Hardware performance for large updates
  2002-09-06 04:33 UTC  Joe Conway <mail@joeconway.com>
` Re: Hardware performance for large updates
  2002-09-06 16:10 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Hardware performance for large updates
  2002-09-07 03:57 UTC  Joe Conway <mail@joeconway.com>
  [4+ messages in thread]

Slow Multi-joins performance
  2002-09-06 10:59 UTC  jlparkinson@bigpond.com <jlparkinson@bigpond.com>

update help
  2001-01-18 02:54 UTC  Carolyn Wong <carolyn@greatpacific.com.au>
` Re: update help
  2001-01-18 03:17 UTC  Tubagus Nizomi <nizomi@dnet.net.id>
` Re: update help
  2001-01-18 03:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: update help
  2001-01-18 03:58 UTC  Carolyn Lu Wong <carolyn@greatpacific.com.au>
` Re: update help
  2001-01-18 04:01 UTC  Carolyn Lu Wong <carolyn@greatpacific.com.au>
` Re: update help
  2001-01-18 04:04 UTC  Josh Berkus <josh@agliodbs.com>
` Re: update help
  2001-01-18 04:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Update  help
  2002-09-03 16:19 UTC  Yudieg@hotmail.com <yudieg@hotmail.com>
` Update Help
  2002-09-03 16:38 UTC  Yudie@axiontech.com <yudie@axiontech.com>
` Re: Update Help
  2002-09-03 18:01 UTC  Oliver Elphick <olly@lfix.co.uk>
` Re: Update Help
  2002-09-03 18:55 UTC  Peter Eisentraut <peter_e@gmx.net>
` Re: Update  help
  2002-09-05 17:29 UTC  Ligia Pimentel <pimentel_ligia@hotmail.com>
  [12+ messages in thread]

fumbling for join syntax
  2002-09-05 14:29 UTC  Daniel Kelley <dkelley@otec.com>
` Re: fumbling for join syntax
  2002-09-05 15:55 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-04-05 14:08 UTC  Magnus Enbom <dot@rockstorm.se>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-04-18 03:43 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-26 00:31 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-26 18:42 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-26 18:53 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-26 19:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-26 19:50 UTC  Magnus Enbom <dot@rockstorm.se>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-26 19:54 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-27 20:59 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-27 21:02 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-27 21:21 UTC  Alvaro Herrera <alvherre@atentus.com>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-27 21:23 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-27 22:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-27 22:11 UTC  Larry Rosenman <ler@lerctr.org>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-27 23:18 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 01:45 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 02:45 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 04:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 08:28 UTC  Magnus Enbom <dot@rockstorm.se>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 11:39 UTC  Larry Rosenman <ler@lerctr.org>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 13:52 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 14:06 UTC  Larry Rosenman <ler@lerctr.org>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 14:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 14:24 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 14:25 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 14:26 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 14:28 UTC  Rod Taylor <rbt@zort.ca>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 14:38 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 14:41 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 15:28 UTC  Vivek Khera <khera@kcilink.com>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 21:01 UTC  Peter Eisentraut <peter_e@gmx.net>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 21:06 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 23:27 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-28 23:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-29 01:14 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-29 02:16 UTC  Larry Rosenman <ler@lerctr.org>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-29 02:18 UTC  Rod Taylor <rbt@zort.ca>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-29 02:29 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-29 05:03 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-29 05:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-29 15:16 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-08-30 03:18 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  2002-09-05 05:27 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [43+ messages in thread]

tree structures in sql - my point of view (with request of comment from joe celko)
  2002-09-03 13:22 UTC  Hubert depesz Lubaczewski <depesz@depesz.pl>
` Re: tree structures in sql - my point of view (with request of comment from joe celko)
  2002-09-03 18:17 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tree structures in sql - my point of view (with request
  2002-09-03 18:42 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: tree structures in sql - my point of view (with request
  2002-09-03 21:59 UTC  mallah@trade-india.com
` Re: tree structures in sql - my point of view (with request
  2002-09-03 22:07 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: tree structures in sql - my point of view (with request of comment from joe celko)
  2002-09-04 17:46 UTC  knut.suebert@web.de
  [6+ messages in thread]

Outer Join with For Update
  2002-09-03 18:05 UTC  alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
` Re: Outer Join with For Update
  2002-09-03 21:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

UPDATE & LIMIT together?
  2002-08-28 16:09 UTC  tp <tp@emaze.net>
` Re: UPDATE & LIMIT together?
  2002-08-28 17:01 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: UPDATE & LIMIT together?
  2002-09-03 08:37 UTC  tp <tp@emaze.net>
` Re: UPDATE & LIMIT together?
  2002-09-03 18:39 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [4+ messages in thread]

Why must the function that a trigger calls return "opaque" ???
  2002-08-29 15:35 UTC  Greg Patnude <GPatnude@adelphia.net>
` Re: [SQL] Why must the function that a trigger calls return "opaque" ???
  2002-08-29 18:05 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why must the function that a trigger calls return
  2002-09-03 14:56 UTC  Darren Ferguson <darren@crystalballinc.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