pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how to use pgsql like mssql
  2007-12-27 00:18 UTC  liuzg2@21cn.com
` Re: how to use pgsql like mssql
  2007-12-27 02:05 UTC  liuzg2@21cn.com
` Re: how to use pgsql like mssql
  2007-12-27 04:54 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: how to use pgsql like mssql
  2007-12-27 04:55 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [4+ messages in thread]

Misnamed field in subquery does not cause error when field name exists in parent query
  2007-12-22 22:12 UTC  Rick Innis <rick.innis@gmail.com>
` Re: Misnamed field in subquery does not cause error when field name exists in parent query
  2007-12-23 00:14 UTC  Michael Glaesemann <grzm@seespotcode.net>
` Re: Misnamed field in subquery does not cause error when field name exists in parent query
  2007-12-24 19:25 UTC  Rick Innis <rick.innis@gmail.com>
  [3+ messages in thread]

slow query - only uses indices
  2007-12-24 14:46 UTC  Marc <pgsql-general@mbreslow.net>
` Re: slow query - only uses indices
  2007-12-24 16:34 UTC  imad <immaad@gmail.com>
` Re: slow query - only uses indices
  2007-12-24 16:41 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [3+ messages in thread]

Different Query plans filtering between dates
  2007-12-24 12:49 UTC  Dani Castaños <danitao.mailists@gmail.com>
` Re: Different Query plans filtering between dates
  2007-12-24 13:12 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [2+ messages in thread]

returning an array as a list of single-column rows... (different approach)
  2007-12-23 23:02 UTC  pgsql@yukonho.de

returning an array as a list fo single-column rows?
  2007-12-23 20:55 UTC  Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
` Re: returning an array as a list fo single-column rows?
  2007-12-23 21:19 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: returning an array as a list fo single-column rows?
  2007-12-23 21:22 UTC  Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
` Re: returning an array as a list fo single-column rows?
  2007-12-23 21:27 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: returning an array as a list fo single-column rows?
  2007-12-23 21:33 UTC  Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
` Re: returning an array as a list fo single-column rows?
  2007-12-23 21:45 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [6+ messages in thread]

passing a multiple join to a function?
  2007-12-17 13:06 UTC  Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
` Re: passing a multiple join to a function?
  2007-12-17 17:27 UTC  Rodrigo De León <rdeleonp@gmail.com>
` Re: passing a multiple join to a function?
  2007-12-23 16:37 UTC  Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
  [3+ messages in thread]

Concatenation through SQL
  2007-12-21 10:33 UTC  Philippe Lang <philippe.lang@attiksystem.ch>
` Re: Concatenation through SQL
  2007-12-21 10:58 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Concatenation through SQL
  2007-12-21 11:07 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Concatenation through SQL
  2007-12-21 11:16 UTC  Leif B. Kristensen <leif@solumslekt.org>
` Re: Concatenation through SQL
  2007-12-21 11:51 UTC  imad <immaad@gmail.com>
` Re: Concatenation through SQL
  2007-12-21 12:07 UTC  Niklas Johansson <spot@tele2.se>
` Re: Concatenation through SQL
  2007-12-21 12:31 UTC  Leif B. Kristensen <leif@solumslekt.org>
` Re: Concatenation through SQL
  2007-12-21 13:48 UTC  Philippe Lang <philippe.lang@attiksystem.ch>
` Re: Concatenation through SQL
  2007-12-21 14:24 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Concatenation through SQL
  2007-12-21 16:01 UTC  Philippe Lang <philippe.lang@attiksystem.ch>
  [10+ messages in thread]

sql query - create replace function
  2007-12-20 05:29 UTC  Iuri Sampaio <iuri.sampaio@gmail.com>
` Re: sql query - create replace function
  2007-12-20 08:31 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

DBLink or setof record functions & type shortcuts
  2007-12-19 15:23 UTC  Jeff Trout <threshar@torgo.978.org>

Insert into and Sequence
  2007-12-17 19:30 UTC  Luigi Pirillo <luigi.pirillo@gmail.com>
` Re: Insert into and Sequence
  2007-12-19 13:21 UTC  Ireneusz Pluta <ipluta@wp.pl>
  [2+ messages in thread]

System catalog future changes
  2007-12-18 16:53 UTC  Steve Midgley <public@misuse.org>
` Re: System catalog future changes
  2007-12-18 17:36 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: System catalog future changes
  2007-12-18 17:38 UTC  Erik Jones <erik@myemma.com>
` Re: System catalog future changes
  2007-12-18 19:29 UTC  Steve Midgley <public@misuse.org>
  [4+ messages in thread]

Describe Table
  2007-12-17 16:56 UTC  danap@dandymadeproductions.com
` Re: Describe Table
  2007-12-17 17:33 UTC  Erik Jones <erik@myemma.com>
` Re: Describe Table
  2007-12-17 17:34 UTC  Colin Wetherbee <cww@denterprises.org>
` Re: Describe Table
  2007-12-17 17:47 UTC  Richard Broersma Jr <rabroersma@yahoo.com>
` Re: Describe Table
  2007-12-17 18:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Describe Table
  2007-12-18 01:21 UTC  danap@dandymadeproductions.com
  [6+ messages in thread]

Bad count of rows estimated for emerge join
  2007-12-15 15:15 UTC  Oleg Kharin <ok@uvadrev.udmnet.ru>

SELECT MAX returns wrong value
  2007-12-13 23:09 UTC  Gavin Baumanis <gavinb@eclinic.com.au>
` Re: SELECT MAX returns wrong value
  2007-12-13 23:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: SELECT MAX returns wrong value
  2007-12-14 17:24 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [3+ messages in thread]

odd error updating - varchar
  2007-12-14 17:02 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: odd error updating - varchar
  2007-12-14 17:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Query design assistance - getting daily totals
  2007-12-12 01:34 UTC  Paul Lambert <paul.lambert@reynolds.com.au>
` Re: Query design assistance - getting daily totals
  2007-12-12 06:31 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Query design assistance - getting daily totals
  2007-12-12 06:39 UTC  Paul Lambert <paul.lambert@reynolds.com.au>
` Re: Query design assistance - getting daily totals
  2007-12-12 07:29 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Query design assistance - getting daily totals
  2007-12-12 15:48 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Query design assistance - getting daily totals
  2007-12-12 19:53 UTC  Rodrigo De León <rdeleonp@gmail.com>
` Re: Query design assistance - getting daily totals
  2007-12-13 21:11 UTC  Steve Midgley <public@misuse.org>
  [7+ messages in thread]

Trigger definition . . .  puzzled
  2007-12-12 21:38 UTC  Rolf A. de By <deby@itc.nl>
` Re: Trigger definition . . .  puzzled
  2007-12-12 22:30 UTC  Erik Jones <erik@myemma.com>
` Re: Trigger definition . . .  puzzled
  2007-12-13 07:19 UTC  Rolf A. de By <deby@itc.nl>
` Re: Trigger definition . . . puzzled
  2007-12-13 15:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trigger definition . . . puzzled
  2007-12-13 15:59 UTC  Rolf A. de By <deby@itc.nl>
` Re: Trigger definition . . . puzzled
  2007-12-13 16:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trigger definition . . . puzzled
  2007-12-13 20:22 UTC  Rolf A. de By <deby@itc.nl>
  [7+ messages in thread]

query assistance
  2003-11-04 15:16 UTC  Jodi Kanter <jkanter@virginia.edu>
` Re: query assistance
  2003-11-04 15:43 UTC  Richard Huxton <dev@archonet.com>
` Re: query assistance
  2003-11-05 04:09 UTC  Michael Glaesemann <grzm@myrealbox.com>
` Query Assistance
  2007-12-12 16:58 UTC  Gary Chambers <gwchamb@gmail.com>
` Re: Query Assistance
  2007-12-12 17:31 UTC  D'Arcy J.M. Cain <darcy@druid.net>
` Re: Query Assistance
  2007-12-12 18:00 UTC  Gary Chambers <gwchamb@gmail.com>
` Re: Query Assistance
  2007-12-12 20:21 UTC  Richard Huxton <dev@archonet.com>
  [7+ messages in thread]

join on three tables is slow
  2007-12-10 01:31 UTC  Gerry Reno <greno@verizon.net>
` Re: join on three tables is slow
  2007-12-10 02:16 UTC  Gerry Reno <greno@verizon.net>
` Re: join on three tables is slow
  2007-12-10 04:45 UTC  Shane Ambler <pgsql@Sheeky.Biz>
` Re: join on three tables is slow
  2007-12-11 04:24 UTC  Gerry Reno <greno@verizon.net>
` Re: join on three tables is slow
  2007-12-11 06:00 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: join on three tables is slow
  2007-12-11 13:23 UTC  Gerry Reno <greno@verizon.net>
` Re: join on three tables is slow
  2007-12-11 14:55 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: join on three tables is slow
  2007-12-11 18:18 UTC  Gerry Reno <greno@verizon.net>
` Re: join on three tables is slow
  2007-12-11 19:46 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: join on three tables is slow
  2007-12-12 04:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: join on three tables is slow
  2007-12-12 14:29 UTC  Gerry Reno <greno@verizon.net>
  [11+ messages in thread]

Function result using execute
  2007-12-12 05:15 UTC  Paul Lambert <paul.lambert@reynolds.com.au>
` Re: Function result using execute
  2007-12-12 06:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Function result using execute
  2007-12-12 06:25 UTC  Erik Jones <erik@myemma.com>
` Re: Function result using execute
  2007-12-12 06:30 UTC  Paul Lambert <paul.lambert@reynolds.com.au>
  [4+ messages in thread]

Foreign Key for multi PK or design question
  2007-12-11 18:20 UTC  PostgreSQL Admin <postgres@productivitymedia.com>
` Re: Foreign Key for multi PK or design question
  2007-12-11 18:35 UTC  Erik Jones <erik@myemma.com>
` Re: Foreign Key for multi PK or design question
  2007-12-11 18:53 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Foreign Key for multi PK or design question
  2007-12-11 19:12 UTC  PostgreSQL Admin <postgres@productivitymedia.com>
` Re: Foreign Key for multi PK or design question
  2007-12-11 19:42 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Foreign Key for multi PK or design question
  2007-12-11 19:48 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Foreign Key for multi PK or design question
  2007-12-11 20:04 UTC  PostgreSQL Admin <postgres@productivitymedia.com>
  [7+ messages in thread]

case sensitivity for tables, columns, and constraint names
  2007-12-11 17:05 UTC  Ertel, Steve <Steve.Ertel@infimatic.com>
` Re: case sensitivity for tables, columns, and constraint names
  2007-12-11 17:24 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: case sensitivity for tables, columns, and constraint names
  2007-12-11 17:30 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: case sensitivity for tables, columns, and constraint names
  2007-12-11 17:35 UTC  Richard Huxton <dev@archonet.com>
  [4+ messages in thread]

Insert Rule, Multiple Insert, Update Problem
  2007-12-11 04:23 UTC  Scott <lists@mail.sael.com.au>
` Re: Insert Rule, Multiple Insert, Update Problem
  2007-12-11 04:50 UTC  Richard Broersma Jr <rabroersma@yahoo.com>
  [2+ messages in thread]

SQL INSERT/TRIGGER Help
  2007-12-10 06:36 UTC  Poovendran Moodley <poovenm@gmail.com>
` Re: SQL INSERT/TRIGGER Help
  2007-12-10 06:44 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: SQL INSERT/TRIGGER Help
  2007-12-10 07:27 UTC  Poovendran Moodley <poovenm@gmail.com>
` Re: SQL INSERT/TRIGGER Help
  2007-12-10 07:43 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: SQL INSERT/TRIGGER Help
  2007-12-10 09:13 UTC  Poovendran Moodley <poovenm@gmail.com>
` Re: SQL INSERT/TRIGGER Help
  2007-12-10 14:08 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
  [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