Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-sql - April 2004

Prev | Next

Jump to day: 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

2004-04-01

Re: Is it normal that functions are so much faster than inline queries Olivier Hubaut (07:07)
Re: DB question - Merging data from one table to another. malia, sean (15:27)
Getting the ranks of results from a query abhi (16:05)
Array_append does not work with Array variables in PL/pgSQL? Josh Berkus (21:20)
Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway (21:36)
Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus (21:48)
Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway (21:51)
Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus (21:57)

2004-04-02

Re: SQL Spec Compliance Questions Joe Conway (07:03)
Re: SQL Spec Compliance Questions Josh Berkus (16:38)
Re: SQL Spec Compliance Questions Joe Conway (16:48)
Re: SQL Spec Compliance Questions Josh Berkus (16:53)
Re: [SQL] SQL Spec Compliance Questions Tom Lane (17:47)

2004-04-03

Re: order of results Gregor Rot (15:08)
Re: SQL Spec Compliance Questions Peter Eisentraut (23:24)
Re: [SQL] SQL Spec Compliance Questions Peter Eisentraut (23:26)

2004-04-05

oracle varray functionality? Postgres User (15:45)
Function To Log Changes Gavin (17:01)
Re: Function To Log Changes Josh Berkus (17:18)
Re: Function To Log Changes Tom Lane (17:39)
group by not returning sorted rows Bret Hughes (21:55)
Re: Entered data appears TWICE in table!!? Jeff Eckermann (22:33)
Re: group by not returning sorted rows Tom Lane (22:34)
Re: Question on pgsql trigger Jeff Eckermann (22:34)
Re: group by not returning sorted rows Stephan Szabo (22:54)
Re: DB question - Merging data from one table to another. scott.marlowe (22:55)

2004-04-06

Re: Rename Schema or Script DDL only a schema Olivier Hubaut (08:17)
Rename Schema or Script DDL only a schema kumar (09:02)
could not devise a query plan SZŰCS Gábor (13:12)
Re: Entered data appears TWICE in table!!? Jeff Eckermann (14:27)
partial unique constraint Robert Treat (14:29)
Re: could not devise a query plan Tom Lane (15:00)
Re: partial unique constraint Stephan Szabo (15:05)
Re: partial unique constraint ries (15:05)
Re: partial unique constraint Tom Lane (15:17)
Re: partial unique constraint Rod Taylor (15:17)
Re: partial unique constraint Achilleus Mantzios (15:18)
Re: partial unique constraint Paul Thomas (15:26)
Re: partial unique constraint Robert Treat (16:38)
Re: group by not returning sorted rows Bret Hughes (16:51)
distinct values without seq scan Bret Hughes (17:06)
SQL Standatd Ricardo Vaz Mannrich (18:21)
Re: SQL Standatd Bruce Momjian (19:01)
Re: could not devise a query plan Tom Lane (19:05)
Re: Function To Log Changes elein (19:06)
Re: partial unique constraint Richard Huxton (19:54)
Help with COPY command Tony Reina (20:31)

2004-04-07

Re: Getting the ranks of results from a query Bruno Wolff III (04:29)
Re: order of results Bruno Wolff III (05:33)
Re: Unknown Exception (piaozhenyu@163.com) ?? (07:38)
Re: Function To Log Changes Erik Thiele (09:42)
Counting rows from two tables in one query Stefan Weiss (10:06)
setting a non-standard date format for the duration of a session Cris Carampa (12:47)
Re: SQL Standatd Ricardo Vaz Mannrich (13:44)
Re: SQL Standatd Bruce Momjian (14:26)
Re: distinct values without seq scan Josh Berkus (15:43)
varray? table of varchar? Postgres User (16:15)
notify and leaks? Theodore Petrosky (16:30)
Crypt() encryption Christina Zhang (17:01)
Re: notify and leaks? Tom Lane (18:27)
Row count after SELECT INTO? Alexander M. Pravking (19:04)
Re: Help with COPY command Tony Reina (19:32)
Re: SQL Standatd Martin Marques (21:16)
Re: SQL Standatd Bruce Momjian (21:59)
Re: SQL Standatd Joe Conway (22:39)

2004-04-08

Re: SQL Standatd Bruce Momjian (00:25)
pgsql multi-database queries yek ching (07:52)
Encoding and result string length kumar (09:32)
Re: Encoding and result string length Richard Huxton (11:00)
SQL challenge--top 10 for each key value? Jeff Boes (19:55)
Re: SQL challenge--top 10 for each key value? Greg Stark (23:33)

2004-04-09

Re: SQL challenge--top 10 for each key value? Rod Taylor (03:31)
Re: SQL challenge--top 10 for each key value? Tom Lane (06:11)
Re: could not devise a query plan SZŰCS Gábor (12:23)
hi sir urgent..required a Query Rajeev Chaudhary, Noida (12:28)
Utility of recursive queries? James Robinson (14:33)
Re: SQL challenge--top 10 for each key value? Josh Berkus (16:06)
Re: Utility of recursive queries? Josh Berkus (16:07)
Re: Utility of recursive queries? Tom Lane (16:35)
Re: SQL challenge--top 10 for each key value? Greg Stark (22:43)

2004-04-10

Re: Crypt() encryption Bruce Momjian (01:06)
Re: pgsql multi-database queries scott.marlowe (01:23)
Re: Counting rows from two tables in one query Greg Sabino Mullane (01:28)
Re: SQL challenge--top 10 for each key value? Rod Taylor (01:29)
Re: SQL challenge--top 10 for each key value? Greg Sabino Mullane (14:35)
Re: Counting rows from two tables in one query Bruno Wolff III (15:09)
Re: hi sir urgent..required a Query Josh Berkus (15:16)
Re: setting a non-standard date format for the duration of a session Josh Berkus (15:19)
Re: SQL challenge--top 10 for each key value? Josh Berkus (15:51)
begin update ... syntax error Kemin Zhou (21:32)
Re: begin update ... syntax error Gregory S. Williamson (21:51)
Re: begin update ... syntax error Adrian Klaver (22:07)
Re: SQL challenge--top 10 for each key value? Troels Arvin (22:13)
Re: SQL challenge--top 10 for each key value? Troels Arvin (22:17)
Re: begin update ... syntax error Yasir Malik (22:19)
Re: SQL challenge--top 10 for each key value? elein (23:46)

2004-04-11

Re: SQL challenge--top 10 for each key value? elein (01:54)
Re: SQL challenge--top 10 for each key value? Greg Stark (04:38)
cursors and for loops? Dennis (04:59)
trigger/for key help Bret Hughes (05:43)
Re: trigger/for key help Stephan Szabo (15:17)
Re: cursors and for loops? Tom Lane (16:00)
Re: SQL challenge--top 10 for each key value? elein (18:20)
Re: cursors and for loops? Dennis (18:46)
Re: trigger/for key help Bret Hughes (19:19)
Re: trigger/for key help Tom Lane (22:00)
Re: trigger/for key help Bret Hughes (22:58)

2004-04-12

Re: trigger/for key help Tom Lane (02:27)
Re: trigger/for key help Bret Hughes (07:18)
Re: Function for numbering rows? CoL (22:21)

2004-04-13

Re: trigger/for key help Greg Stark (06:20)
Re: cursors and for loops? Richard Huxton (08:31)
relation X does not exist Laura Scott (12:49)
Re: trigger/for key help Tom Lane (13:25)
Formatting Functions and Group By Terry Brick (16:13)
Re: Formatting Functions and Group By Bruno Wolff III (16:45)
Re: Formatting Functions and Group By Tom Lane (17:33)
Re: trigger/for key help Greg Stark (17:36)
Re: Formatting Functions and Group By Terry Brick (17:49)
Re: SQL challenge--top 10 for each key value? Jeff Boes (18:34)
Re: trigger/for key help Tom Lane (18:35)
function returning array Dennis (22:41)

2004-04-14

Re: function returning array Tom Lane (03:30)
Re: function returning array Joe Conway (04:10)
Database triggers Charity M (13:57)
Re: Help with COPY command Christoph Haller (15:42)
Re: Help with COPY command Tony and Bryn Reina (15:54)
full join...using and version of pgsql Tina Messmann (17:05)
Re: full join...using and version of pgsql scott.marlowe (20:39)

2004-04-15

SET idiom in insert statement Kenneth Gonsalves (01:38)
type conversions sad (04:04)
Grant permission to all objects of user A to user B kumar (06:58)
SQL script vickr1z (08:22)
Re: SQL script Richard Huxton (09:12)
Re: problem porting MySQL SQL to Postgres Reinoud van Leeuwen (09:55)
problem porting MySQL SQL to Postgres Dan Field (10:25)
Re: problem porting MySQL SQL to Postgres Paul Thomas (11:15)
Re: problem porting MySQL SQL to Postgres CoL (11:30)
Re: problem porting MySQL SQL to Postgres Martin Marques (11:30)
Re: function returning array Dennis (12:16)
Re: Database triggers Charles Wilt (13:50)
Re: function returning array Dennis (14:03)
Re: cursors and for loops? Jan Wieck (14:50)
Re: function returning array Joe Conway (16:10)
Re: Row count after SELECT INTO? Christoph Haller (16:58)
Re: Grant permission to all objects of user A to user B Christoph Haller (17:07)
Update is very slow on a bigger table Dimitar Georgievski (21:07)
Re: Update is very slow on a bigger table Tom Lane (22:51)
Re: Update is very slow on a bigger table CoL (22:53)

2004-04-16

Re: Database triggers Charity M (12:32)
Re: Update is very slow on a bigger table Dimitar Georgievski (14:40)
What is the best way of writing update rule on view with joined tables? Cornelius Grotjahn (17:43)
Re: Update is very slow on a bigger table Yudie (17:47)
Querying From two databases Pallav Kalva (17:55)
Querying two databases Pallav Kalva (18:02)
Re: Querying two databases Rajesh Kumar Mallah (18:37)
run application from trigger? Yudie (20:21)

2004-04-17

ANN: www.SQL-Scripts.Com Greg (05:45)
Re: run application from trigger? Richard Huxton (09:37)
Re: Update is very slow on a bigger table Bruno Wolff III (15:13)

2004-04-18

Concatenate results of a single column query Marco Lazzeri (14:36)
Concatenate results of a single column query Marco Lazzeri (15:44)
Re: Concatenate results of a single column query Greg Stark (17:42)
Re: problem porting MySQL SQL to Postgres Markus Bertheau (18:37)
Re: problem porting MySQL SQL to Postgres Paul Thomas (19:24)

2004-04-19

Re: problem porting MySQL SQL to Postgres Bruno Wolff III (03:21)
three-way join Gary Stainburn (12:47)
Re: Concatenate results of a single column query Greg Stark (13:45)
Re: three-way join Stijn Vanroye (14:06)
Re: three-way join Gary Stainburn (15:01)
Re: Concatenate results of a single column query Christoph Haller (15:15)
Re: Update is very slow on a bigger table scott.marlowe (15:33)
Re: Concatenate results of a single column query CoL (15:47)
Prepared Statements and large where-id-in constant blocks? James Robinson (15:56)
Re: three-way join - solved Gary Stainburn (16:13)
Re: three-way join Bruno Wolff III (17:45)
Re: Querying From two databases Bruce Momjian (18:30)
Re: [SQL] SQL script scott.marlowe (20:17)
Can someone tell me why this statement is failing? P A (20:31)
Re: Prepared Statements and large where-id-in constant blocks? Oliver Jowett (22:21)

2004-04-20

Re: [SQL] Prepared Statements and large where-id-in constant blocks? Tom Lane (01:02)
Re: relation X does not exist Tom Lane (01:11)
Re: Prepared Statements and large where-id-in constant blocks? Oliver Jowett (02:57)
Re: three-way join - solved Stijn Vanroye (07:26)
Re: Can someone tell me why this statement is failing? Martin Marques (14:40)
Re: Can someone tell me why this statement is failing? Edmund Bacon (14:42)
Re: Can someone tell me why this statement is failing? Rod Taylor (15:32)
Re: Prepared Statements and large where-id-in constant blocks? James Robinson (15:35)
transaction H.J. Sanders (19:14)
Follow-up: FK constraint performance ow (19:25)
Syntax for cmd to EXEC...how many quotes? David B (23:24)

2004-04-21

Re: transaction Bruno Wolff III (02:00)
staggered query? Vincent Ladlad (02:53)
Re: Follow-up: FK constraint performance ow (03:45)
Re: staggered query? Denis P Gohel (07:11)
Re: transaction denis (07:28)
Re: Syntax for cmd to EXEC...how many quotes? denis (08:44)
Re: Can someone tell me why this statement is failing? denis (08:53)
Re: transaction Andrew Sullivan (10:13)
Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan (10:30)

Prev | Next

Jump to day: 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group