Home > mailing lists

Mailing lists [pgsql-sql]

1 July 2005

08:53 UNIT-tests and SQL KÖPFERL Robert
09:04 SQLCloseCursor() or SQLFreeStmt does not free memory allcated to read CLOB field in Oracle. Vadivel Subramaniam
13:58 'show full processlist' in postgres? Erik Wasser
16:14 Some help please Nick Stone
16:24 Re: 'show full processlist' in postgres? Jim Buttafuoco
17:13 Re: 'show full processlist' in postgres? Erik Wasser
17:28 Re: Some help please Josh Berkus
17:44 Re: Some help please Nick Stone
19:43 Re: 'show full processlist' in postgres? Tom Lane
20:19 Re: [despammed] Re: 'show full processlist' in postgres? Andreas Kretschmer

4 July 2005

11:14 Help on Procedure running external function Din Adrian
11:58 select values from interval Josep Sanmartí
12:55 Re: Help on Procedure running external function Zac
13:10 Re: Help on Procedure running external function Din Adrian
15:20 Re: Help on Procedure running external function KÖPFERL Robert
15:28 Re: Help on Procedure running external function Zac
17:00 Re: Help on Procedure running external function Bruno Wolff III
17:03 Re: select values from interval Bruno Wolff III

5 July 2005

05:05 Recursive function Gnanavel Shanmugam
05:33 Re: Recursive function Gnanavel Shanmugam
06:29 Re: Recursive function Nick Stone
09:11 Re: Help on Procedure running external function Din Adrian
09:47 Create connection with Oracle database from Postgres plpgsql function Dinesh Pandey
10:02 Re: Create connection with Oracle database from Postgres plpgsql function Michael Glaesemann
11:48 Re: Help on Procedure running external function Zac
12:06 Re: Help on Procedure running external function Din Adrian
12:39 Re: Help on Procedure running external function Bruno Wolff III
12:52 Re: Help on Procedure running external function Din Adrian
14:26 Re: Create connection with Oracle database from Postgres plpgsql Bricklen Anderson

6 July 2005

10:00 left joins Grant Morgan
10:30 Re: left joins Richard Huxton
10:33 Re: left joins Nick Stone
10:51 Re: left joins Grant Morgan
14:44 Re: left joins Tom Lane
19:32 Prepare plan in plpgsql Jocelyn Turcotte
19:56 Re: Prepare plan in plpgsql Tom Lane

7 July 2005

00:18 Re: left joins Ragnar Hafstað
01:12 Re: left joins Tony Wasson
17:50 getting back autonumber just inserted mail TechEvolution
18:03 Re: getting back autonumber just inserted Alvaro Herrera
18:21 Re: getting back autonumber just inserted mail TechEvolution
19:15 Re: getting back autonumber just inserted Alvaro Herrera
20:14 Re: getting back autonumber just inserted Theodore Petrosky
20:22 Re: getting back autonumber just inserted Scott Marlowe
20:25 Re: getting back autonumber just inserted mail TechEvolution
20:37 Re: getting back autonumber just inserted Michael Fuhr
20:57 Re: getting back autonumber just inserted Michael Fuhr
22:26 Re: getting back autonumber just inserted PFC
22:42 Re: getting back autonumber just inserted Alvaro Herrera
22:45 Re: getting back autonumber just inserted Michael Fuhr
22:48 Make COUNT(*) Faster? Varun Mehta
23:54 Re: getting back autonumber just inserted PFC
23:56 Re: getting back autonumber just inserted PFC

8 July 2005

01:50 Re: getting back autonumber just inserted Michael Fuhr
02:22 Re: Make COUNT(*) Faster? Michael Fuhr
03:03 Re: getting back autonumber just inserted PFC
03:29 Re: getting back autonumber just inserted Michael Fuhr
04:04 Re: Make COUNT(*) Faster? Chris Browne
04:27 Re: Make COUNT(*) Faster? Tom Lane
05:48 two sums in one query Kenneth Gonsalves
05:56 list admin note:Fwd: RE: two sums in one query Kenneth Gonsalves
06:22 Re: PostgreSQL and Delphi 6 Mathew Winters
07:36 Re: two sums in one query Kenneth Gonsalves
11:54 Re: getting back autonumber ... Another MsSQL Comparation Question jimmy.olsen
12:32 Re: getting back autonumber ... Another MsSQL Comparation Question Michael Fuhr
13:27 Re: getting back autonumber just inserted Bruno Wolff III
13:49 Re: two sums in one query PFC
14:10 Re: two sums in one query Bruno Wolff III
14:12 Re: Make COUNT(*) Faster? Steve Wampler
14:34 Re: Make COUNT(*) Faster? Bruno Wolff III
14:49 Re: two sums in one query PFC
15:07 Re: Make COUNT(*) Faster? Steve Wampler
15:25 Re: Make COUNT(*) Faster? Rod Taylor
15:30 Re: Make COUNT(*) Faster? Dawid Kuroczko
15:31 Re: Make COUNT(*) Faster? Andrew Sullivan
15:34 Re: Make COUNT(*) Faster? Dawid Kuroczko
15:35 Re: Make COUNT(*) Faster? Tom Lane
15:41 Re: Make COUNT(*) Faster? Rod Taylor
15:55 Re: two sums in one query Bruno Wolff III
16:00 Re: Make COUNT(*) Faster? Steve Wampler
16:08 Re: Make COUNT(*) Faster? PFC
16:10 Index creation question for expression (col1 || '-' || col2) Ying Lu
16:14 Re: Make COUNT(*) Faster? Tom Lane
16:15 Re: Index creation question for expression (col1 || '-' || col2) Tom Lane
16:32 Re: Index creation question for expression (col1 || '-' || col2) Michael Fuhr
16:50 Re: Make COUNT(*) Faster? Christopher Browne
16:57 Re: Index creation question for expression (col1 || '-' || col2) Bruno Wolff III
17:09 Re: Index creation question for expression (col1 || '-' || Ying Lu
17:09 Re: Make COUNT(*) Faster? Steve Wampler
19:51 Re: Make COUNT(*) Faster? Alvaro Herrera
20:55 Clustering problem CG
23:24 Re: Clustering problem PFC

9 July 2005

12:58 Re: getting back autonumber just inserted jimmy.olsen

10 July 2005

01:00 Re: getting back autonumber just inserted Mischa Sandberg
12:30 Re: Make COUNT(*) Faster? Harald Fuchs
16:10 Re: Make COUNT(*) Faster? Tom Lane

11 July 2005

15:32 PostgreSQL - ERROR: Cannot cast type character varying to integer Mauricio Fernandez
18:02 Re: Clustering problem CG

12 July 2005

18:17 Copy user privileges Graham Vickrage
18:18 Re: PostgreSQL - ERROR: Cannot cast type character varying to integer Mauricio Fernandez
18:33 Re: PostgreSQL - ERROR: Cannot cast type character varying to Christoph Haller
19:13 Re: Copy user privileges Tom Lane
19:30 Re: Copy user privileges Michael Fuhr
21:25 dynamically loaded functions TJ O'Donnell
21:27 How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format Dinesh Pandey

13 July 2005

02:08 Re: dynamically loaded functions Michael Fuhr
09:13 Generating a range of integers in a query Aaron Bingham
10:21 Re: Generating a range of integers in a query Michael Glaesemann
11:31 Re: Copy user privileges Graham Vickrage
13:28 Re: Generating a range of integers in a query Jim Buttafuoco
16:54 Re: Generating a range of integers in a query Scott Marlowe
21:05 Re: getting back autonumber just inserted Vivek Khera

14 July 2005

01:50 Sql Query help: Remove Sub Selects Rob
01:53 Dynamic Offset Determination David Blankley
01:53 Re: Dynamic Offset Determination David Blankley
02:17 function parameters : bug? Richard Hayward
02:17 Re: two sums in one query Ramakrishnan Muralidharan
02:18 ORDER records based on parameters in IN clause Riya Verghese
02:31 Possible to use a table to tell what table to select from? Frank Hagstrom
02:32 Re: getting back autonumber just inserted Larry Meadors
02:32 Re: getting back autonumber just inserted Larry Meadors
08:16 Re: function parameters : bug? Richard Huxton
08:45 Re: Possible to use a table to tell what table to select from? Richard Huxton
13:04 Re: getting back autonumber just inserted Bruno Wolff III

15 July 2005

05:10 How to obtain the list of data table name only sunny076@yahoo.com
05:14 problem (bug?) with "in (subquery)" Luca Pireddu
05:18 Yearly Archival System Using PostgreSQL Vivek
05:21 difference between all RDBMSs Dhanashree
05:22 [postgres] Betrifft: Datumsfeld leer lassen marco_0160
05:24 Help With complex join spinto@virtualslo.com
05:25 Error on dynamic code. Mark J Camilleri
05:27 Re: Possible to use a table to tell what table to select from? Frank Hagstrom
06:43 Re: Help With complex join Gnanavel S
09:00 Re: difference between all RDBMSs Richard Huxton
09:01 Re: Help With complex join Richard Huxton
09:16 Re: How to obtain the list of data table name only Richard Huxton
09:46 Re: difference between all RDBMSs Kenneth Gonsalves
11:48 Re: Yearly Archival System Using PostgreSQL Michael Fuhr
12:16 Re: How to obtain the list of data table name only Neil Dugan
13:34 Re: problem (bug?) with "in (subquery)" Michael Fuhr
13:59 Re: problem (bug?) with "in (subquery)" Tom Lane
14:11 Re: problem (bug?) with "in (subquery)" Michael Fuhr
14:40 Postgres for Fedora Core 2 OS **************** Dinesh Pandey
14:58 Re: problem (bug?) with "in (subquery)" Tom Lane
15:52 Re: problem (bug?) with "in (subquery)" Luca Pireddu
17:13 Re: problem (bug?) with "in (subquery)" Tom Lane
19:26 Re: Error on dynamic code. John DeSoi

18 July 2005

06:15 Re: Postgres for Fedora Core 2 OS **************** Richard Huxton
12:22 Create trigger for auto update function Andrei Bintintan
13:21 Re: Create trigger for auto update function PFC
13:32 Re: Create trigger for auto update function daq
15:40 About retrieving objects' priviledge info such as grantee & its privileges for a specific object (view, table, function, etc.) Ying Lu
16:51 Dumping table definitions Mark Fenbers
17:02 Re: Dumping table definitions Tom Lane
17:02 Re: Dumping table definitions Jim Buttafuoco
17:09 Re: Dumping table definitions Dawid Kuroczko

19 July 2005

07:53 Re: Create trigger for auto update function Andy
08:11 Re: Create trigger for auto update function daq
09:16 Re: Create trigger for auto update function Richard Huxton
09:17 Re: Create trigger for auto update function >> SOLVED!!! Andy
09:26 Re: Create trigger for auto update function Andy
10:10 Re: Postgres for Fedora Core 2 OS **************** Halley Pacheco de Oliveira
14:51 echo/printf function in plpgsql Andreas Joseph Krogh
15:31 Re: echo/printf function in plpgsql Richard Huxton
15:58 Re: echo/printf function in plpgsql Andreas Joseph Krogh
17:11 funstions for parsing words John Kopanas
19:01 Re: funstions for parsing words Tony Wasson
20:10 Re: echo/printf function in plpgsql Tony Wasson
20:37 Re: echo/printf function in plpgsql Andreas Joseph Krogh
20:44 Coalesce() in outer join between views Chris Travers
22:54 Re: difference between all RDBMSs Chris Travers
23:40 Re: echo/printf function in plpgsql John DeSoi

20 July 2005

07:21 Re: echo/printf function in plpgsql Andreas Joseph Krogh
12:47 ids from grouped rows Lindsay
14:47 Re: ids from grouped rows Ragnar Hafstað
15:48 Re: [despammed] Re: 'show full processlist' in postgres? Erik Wasser

21 July 2005

13:58 Are long term never commited SELECT statements are a problem? Erik Wasser
14:20 Can SELECT statements throw an error Erik Wasser
14:33 Re: Are long term never commited SELECT statements are a Achilleus Mantzios
14:35 Re: Can SELECT statements throw an error Tom Lane
15:19 Re: Are long term never commited SELECT statements are a problem? Michael Fuhr
15:41 Re: Are long term never commited SELECT statements are a problem? Erik Wasser
16:14 Re: Are long term never commited SELECT statements are a problem? Alvaro Herrera
16:23 Re: Are long term never commited SELECT statements are a problem? Michael Fuhr

22 July 2005

09:24 Error when using array variable Dongsoo Yoon
09:29 Error when using array variable Dongsoo Yoon
12:13 Using subselects as joins in POstgeSQL (possible?, examples) frank church
12:58 Re: Are long term never commited SELECT statements are a pr KÖPFERL Robert
13:21 Re: Using subselects as joins in POstgeSQL (possible?, examples) Pascual De Ruvo
13:52 Re: Error when using array variable Michael Fuhr
14:03 Convert numeric to money lucas@presserv.org
15:33 Re: Error when using array variable Gnanavel S
15:49 Multi-column returns from pgsql Mark R. Dingee
16:57 Re: Multi-column returns from pgsql Jim Buttafuoco
17:29 Re: Convert numeric to money Bruno Wolff III
18:11 Re: Multi-column returns from pgsql Tony Wasson
19:11 Tigger David Hofmann
19:17 Re: Tigger Bricklen Anderson
19:25 Re: Tigger David Hofmann
19:28 Re: Tigger Bricklen Anderson
19:33 Re: Tigger Jaime Casanova
19:35 Re: Tigger Bricklen Anderson
19:56 Re: Tigger David Hofmann
23:39 Re: Error when using array variable Michael Fuhr

23 July 2005

04:56 Re: Error when using array variable Tom Lane
06:30 Is there a type like a growable array, similar Vector at Java language in postgreSQL? Dongsoo Yoon
10:00 Re: Is there a type like a growable array, similar Vector at Richard Huxton
12:57 Re: Multi-column returns from pgsql Jim Buttafuoco

24 July 2005

16:19 Re: solved: Coalesce() in outer join between views Chris Travers
16:19 Counting Row Ricky Sutanto
16:21 Different encodings in different DBs in same cluster Jamie Lawrence
16:21 Counting Row Ricky Sutanto
16:23 Re: ids from grouped rows Weinzierl Stefan
16:24 Re: difference between all RDBMSs Alexander Schreiber
16:45 Re: Counting Row PFC
18:42 Re: Different encodings in different DBs in same cluster Tom Lane
22:07 Re: Counting Row Pascual De Ruvo

25 July 2005

07:58 Re: Convert numeric to money Mauricio Fernandez
08:54 int to date Daniel Drotos
16:13 Re: int to date Bruno Wolff III
16:38 update vs unique index jacekp@poczta.wprost.pl
16:52 Re: update vs unique index Alvaro Herrera
17:31 Closes Match Christian Rusa
17:50 Re: Closes Match Bruno Wolff III
18:58 Re: Closes Match Jonathan Lam

26 July 2005

07:43 REINDEX DATABASE Eugene E.
13:50 Re: REINDEX DATABASE Christopher Browne
14:29 Re: REINDEX DATABASE Achilleus Mantzios
18:04 Re: REINDEX DATABASE Chris Browne
19:02 Joining two large tables on a tiny subset of rows Dmitri Bichko

27 July 2005

03:48 Re: Joining two large tables on a tiny subset of rows Gnanavel S
06:20 Re: REINDEX DATABASE Achilleus Mantzios
07:15 Re: Joining two large tables on a tiny subset of rows Richard Huxton
16:04 Re: REINDEX DATABASE Chris Browne
20:08 Foreign key with check? Jeff Boes
20:37 Re: Foreign key with check? Bruno Wolff III

28 July 2005

05:09 Re: REINDEX DATABASE Tom Lane
06:51 Re: REINDEX DATABASE Achilleus Mantzios
15:33 Re: Convert numeric to money codeWarrior

29 July 2005

13:33 Why are these queries so different in time? Olivier Hubaut
13:34 calling EXECUTE on any exception gherzig@fmed.uba.ar
14:45 Re: calling EXECUTE on any exception Michael Fuhr
15:45 Re: Why are these queries so different in time? Richard Huxton
15:56 Re: calling EXECUTE on any exception gherzig@fmed.uba.ar
17:10 CREATE TABLE AS SELECT Jeff Boes
18:53 Re: CREATE TABLE AS SELECT daq
23:39 How to loop though an array plpgsql? Matthew Schumacher

30 July 2005

04:16 bug in information_schema? Kyle Bateman
13:15 Re: How to loop though an array plpgsql? Michael Fuhr
15:15 Re: bug in information_schema? Tom Lane