pgsql-sql - July 2005

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

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

July 1, 2005

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

July 4, 2005

Thread Author Time
select values from interval Josep Sanmartí 12:00
Re: Help on Procedure running external function Zac 12:47
Re: Help on Procedure running external function KÖPFERL Robert 15:20
Re: Help on Procedure running external function Zac 15:27
Re: Help on Procedure running external function Bruno Wolff III 17:00
Re: select values from interval Bruno Wolff III 17:03
Help on Procedure running external function Din Adrian 21:14
Re: Help on Procedure running external function Din Adrian 23:10

July 5, 2005

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

July 6, 2005

Thread Author Time
left joins Grant Morgan 10:01
Re: left joins Richard Huxton 10:30
Re: left joins Nick Stone 10:33
Re: left joins Grant Morgan 10:52
Re: left joins Tom Lane 14:44
Prepare plan in plpgsql Jocelyn Turcotte 19:32
Re: Prepare plan in plpgsql Tom Lane 19:55

July 7, 2005

Thread Author Time
Re: left joins Ragnar Hafstað 00:19
Re: left joins Tony Wasson 01:11
getting back autonumber just inserted mail TechEvolution 17:50
Re: getting back autonumber just inserted Alvaro Herrera 18:03
Re: getting back autonumber just inserted mail TechEvolution 18:21
Re: getting back autonumber just inserted Alvaro Herrera 19:15
Re: getting back autonumber just inserted Theodore Petrosky 20:14
Re: getting back autonumber just inserted Scott Marlowe 20:21
Re: getting back autonumber just inserted mail TechEvolution 20:24
Re: getting back autonumber just inserted Michael Fuhr 20:37
Re: getting back autonumber just inserted Larry Meadors 20:47
Re: getting back autonumber just inserted Michael Fuhr 20:57
ORDER records based on parameters in IN clause Riya Verghese 21:01
Re: getting back autonumber just inserted PFC 22:26
Re: getting back autonumber just inserted Alvaro Herrera 22:42
Re: getting back autonumber just inserted Michael Fuhr 22:44
Make COUNT(*) Faster? Varun Mehta 22:48
Re: getting back autonumber just inserted PFC 23:54
Re: getting back autonumber just inserted PFC 23:56

July 8, 2005

Thread Author Time
Re: getting back autonumber just inserted Michael Fuhr 01:49
Re: getting back autonumber just inserted Larry Meadors 02:09
Re: Make COUNT(*) Faster? Michael Fuhr 02:21
Re: getting back autonumber just inserted PFC 03:03
Re: getting back autonumber just inserted Michael Fuhr 03:28
Re: Make COUNT(*) Faster? Chris Browne 03:39
Re: Make COUNT(*) Faster? Tom Lane 04:27
two sums in one query Kenneth Gonsalves 05:48
list admin note:Fwd: RE: two sums in one query Kenneth Gonsalves 05:56
Re: PostgreSQL and Delphi 6 Mathew Winters 06:22
Re: two sums in one query Ramakrishnan Muralidharan 06:32
Re: two sums in one query Kenneth Gonsalves 07:36
Re: getting back autonumber ... Another MsSQL Comparation Question jimmy.olsen 11:56
Re: getting back autonumber ... Another MsSQL Comparation Question Michael Fuhr 12:32
Re: getting back autonumber just inserted Bruno Wolff III 13:27
Re: two sums in one query PFC 13:49
Re: two sums in one query Bruno Wolff III 14:07
Re: Make COUNT(*) Faster? Steve Wampler 14:12
Re: Make COUNT(*) Faster? Bruno Wolff III 14:35
Re: two sums in one query PFC 14:49
Re: Make COUNT(*) Faster? Steve Wampler 15:07
Re: Make COUNT(*) Faster? Rod Taylor 15:22
Re: Make COUNT(*) Faster? Dawid Kuroczko 15:30
Re: Make COUNT(*) Faster? Andrew Sullivan 15:31
Re: Make COUNT(*) Faster? Dawid Kuroczko 15:34
Re: Make COUNT(*) Faster? Tom Lane 15:35
Re: Make COUNT(*) Faster? Rod Taylor 15:38
Re: two sums in one query Bruno Wolff III 15:55
Re: Make COUNT(*) Faster? Steve Wampler 16:00
Re: Make COUNT(*) Faster? PFC 16:08
Index creation question for expression (col1 || '-' || col2) Ying Lu 16:08
Re: Make COUNT(*) Faster? Tom Lane 16:12
Re: Index creation question for expression (col1 || '-' || col2) Tom Lane 16:15
Re: Index creation question for expression (col1 || '-' || col2) Michael Fuhr 16:32
Re: Index creation question for expression (col1 || '-' || col2) Bruno Wolff III 16:57
Re: Make COUNT(*) Faster? Steve Wampler 17:08
Re: Index creation question for expression (col1 || '-' || Ying Lu 17:08
Re: Make COUNT(*) Faster? Christopher Browne 17:09
Re: Make COUNT(*) Faster? Alvaro Herrera 19:51
Possible to use a table to tell what table to select from? Frank Hagstrom 20:32
Clustering problem CG 20:55
Re: Clustering problem PFC 23:24

July 9, 2005

Thread Author Time
Re: getting back autonumber just inserted jimmy.olsen 12:59

July 10, 2005

Thread Author Time
Re: getting back autonumber just inserted Mischa Sandberg 01:00
function parameters : bug? Richard Hayward 10:52
Re: Make COUNT(*) Faster? Harald Fuchs 12:19
Re: Make COUNT(*) Faster? Tom Lane 16:10
Sql Query help: Remove Sub Selects Rob 23:20

July 11, 2005

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

July 12, 2005

Thread Author Time
dynamically loaded functions TJ O'Donnell 03:16
How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format Dinesh Pandey 03:39
Re: PostgreSQL - ERROR: Cannot cast type character varying to Christoph Haller 11:34
Copy user privileges Graham Vickrage 12:21
Re: PostgreSQL - ERROR: Cannot cast type character varying to integer Mauricio Fernandez 12:49
Re: Copy user privileges Tom Lane 19:12
Re: Copy user privileges Michael Fuhr 19:29

July 13, 2005

Thread Author Time
Re: dynamically loaded functions Michael Fuhr 02:08
Generating a range of integers in a query Aaron Bingham 09:13
Re: Generating a range of integers in a query Michael Glaesemann 10:20
Re: Copy user privileges Graham Vickrage 11:31
Re: Generating a range of integers in a query Jim Buttafuoco 13:22
Dynamic Offset Determination David Blankley 15:28
Re: Dynamic Offset Determination David Blankley 16:06
Re: Generating a range of integers in a query Scott Marlowe 16:54
Re: [SQL] dynamically loaded functions TJ O'Donnell 17:24
Re: getting back autonumber just inserted Vivek Khera 21:05

July 14, 2005

Thread Author Time
problem (bug?) with "in (subquery)" Luca Pireddu 07:34
Error on dynamic code. Mark J Camilleri 07:46
Re: function parameters : bug? Richard Huxton 08:14
Re: Possible to use a table to tell what table to select from? Richard Huxton 08:31
Yearly Archival System Using PostgreSQL Vivek 09:24
[postgres] Datumsfeld leer lassen Stefan Miefert 10:40
Re: getting back autonumber just inserted Bruno Wolff III 13:05
difference between all RDBMSs Dhanashree 14:23
Re: Possible to use a table to tell what table to select from? Frank Hagstrom 15:26
[postgres] Betrifft: Datumsfeld leer lassen marco_0160 15:48
Help With complex join spinto 21:34
How to obtain the list of data table name only sunny076 22:24

July 15, 2005

Thread Author Time
Re: Help With complex join Gnanavel S 06:43
Re: difference between all RDBMSs Richard Huxton 08:48
Re: How to obtain the list of data table name only Richard Huxton 08:52
Re: Help With complex join Richard Huxton 08:57
Re: difference between all RDBMSs Kenneth Gonsalves 09:46
Re: Yearly Archival System Using PostgreSQL Michael Fuhr 11:48
Re: How to obtain the list of data table name only Neil Dugan 12:16
Re: problem (bug?) with "in (subquery)" Michael Fuhr 13:34
Re: problem (bug?) with "in (subquery)" Tom Lane 13:59
Re: problem (bug?) with "in (subquery)" Michael Fuhr 14:10
Postgres for Fedora Core 2 OS **************** Dinesh Pandey 14:38
Re: problem (bug?) with "in (subquery)" Tom Lane 14:58
Re: problem (bug?) with "in (subquery)" Luca Pireddu 15:52
Re: Postgres for Fedora Core 2 OS **************** Dianne Yumul 16:54
Re: Postgres for Fedora Core 2 OS **************** Dianne Yumul 16:57
Re: problem (bug?) with "in (subquery)" Tom Lane 17:12
Re: Postgres for Fedora Core 2 OS **************** Devrim GUNDUZ 18:03
Re: Error on dynamic code. John DeSoi 19:26

July 17, 2005

Thread Author Time
Re: difference between all RDBMSs Alexander Schreiber 17:34

July 18, 2005

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

July 19, 2005

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

July 20, 2005

Thread Author Time
Re: echo/printf function in plpgsql Andreas Joseph Krogh 07:21
ids from grouped rows Lindsay 12:46
Re: ids from grouped rows Weinzierl Stefan 14:09
Re: ids from grouped rows Ragnar Hafstað 14:50
Re: [despammed] Re: 'show full processlist' in postgres? Erik Wasser 15:48
Re: solved: Coalesce() in outer join between views 📎 Chris Travers 16:43

July 21, 2005

Thread Author Time
Re: [SQL] dynamically loaded functions Neil Dugan 04:16
Error when using array variable Dongsoo Yoon 09:29
Counting Row Ricky Sutanto 10:33
Are long term never commited SELECT statements are a problem? Erik Wasser 13:57
Can SELECT statements throw an error Erik Wasser 14:20
Re: Are long term never commited SELECT statements are a Achilleus Mantzios 14:21
Re: Can SELECT statements throw an error Tom Lane 14:35
Re: Are long term never commited SELECT statements are a problem? Michael Fuhr 15:18
Re: Are long term never commited SELECT statements are a problem? Erik Wasser 15:40
Re: Are long term never commited SELECT statements are a problem? Alvaro Herrera 16:13
Re: Are long term never commited SELECT statements are a problem? Michael Fuhr 16:23
Different encodings in different DBs in same cluster Jamie Lawrence 18:32

July 22, 2005

Thread Author Time
Counting Row Ricky Sutanto 03:13
Is there a type like a growable array, similar Vector at Java language in postgreSQL? Dongsoo Yoon 06:30
Error when using array variable Dongsoo Yoon 09:24
Re: Error when using array variable Gnanavel S 09:37

Browse Archives

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