pgsql-sql - August 2006

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

Aug. 1, 2006

Thread	Author	Time
Re: Joining a result set from four (4) tables	John Tregea	00:12
finding unused indexes?	George Pavlov	16:05
Re: finding unused indexes?	Jim Buttafuoco	16:10
Re: finding unused indexes?	Brad Nicholson	16:11
Re: Joining a result set from four (4) tables	Aaron Bono	19:32
viewing the description of tables from python DB-API	Daniel Joo	22:30
Re: viewing the description of tables from python DB-API	Alvaro Herrera	23:00
Re: viewing the description of tables from python DB-API	Rodrigo De Leon	23:14

Aug. 2, 2006

Thread	Author	Time
Re: Joining a result set from four (4) tables	John Tregea	03:55
alter column type from boolean to char with default doesn't work	Markus Bertheau	12:46
Problem while using lo_import and lo_export	Penchalaiah P.	12:54
How to cal function in one another	Penchalaiah P.	12:55
How to use table from one database to another	Penchalaiah P.	12:57
i need informarion regarding functions and arrays...	Penchalaiah P.	13:02
Re: How to use table from one database to another	Richard Broersma Jr	13:12
Re: alter column type from boolean to char with default doesn't work	Tom Lane	13:19
Re: alter column type from boolean to char with default	Rod Taylor	13:56
Re: viewing the description of tables from python DB-API	Scott Marlowe	16:22
Re: alter column type from boolean to char with default	Tom Lane	16:36
Re: Joining a result set from four (4) tables	Aaron Bono	18:01

Aug. 3, 2006

Thread	Author	Time
Re: Problem while using lo_import and lo_export	Aaron Bono	00:09
Re: How to cal function in one another	Aaron Bono	00:11
Re: i need informarion regarding functions and arrays...	Aaron Bono	00:13
Re: Joining a result set from four (4) tables	John Tregea	00:51
Re: Problem while using lo_import and lo_export	Rodrigo De León	01:33
Re: Problem while using lo_import and lo_export	Aaron Bono	04:05
Re: SELECT all fields except two	Andrew Hammond	16:16
Function not return zero record	Sylvain Racine	16:58
Error: out of memory in create table as 📎	jason nordwick	17:04
Re: Function not return zero record	Richard Huxton	17:29
Re: alter column type from boolean to char with default	Andrew Hammond	18:49
Re: Error: out of memory in create table as	Tom Lane	19:37
Re: alter column type from boolean to char with default	Tom Lane	19:40

Aug. 4, 2006

Thread	Author	Time
[No subject]	Jonathan Sinclair	06:55
autoupdating mtime column	David Garamond	12:16
Re: autoupdating mtime column	Richard Huxton	12:49
Re: autoupdating mtime column	David Garamond	15:11
Re: autoupdating mtime column	Rodrigo De León	15:39
Re: autoupdating mtime column	David Garamond	15:51
Re: autoupdating mtime column	Richard Huxton	16:05
Re: autoupdating mtime column	Tom Lane	16:10
Re: autoupdating mtime column	David Garamond	17:36
Re: autoupdating mtime column	Richard Huxton	18:18
select query optimization	sergey	18:55
to_dec()	Melvin Davidson	21:23

Aug. 5, 2006

Thread	Author	Time
Re: autoupdating mtime column	David Garamond	01:27

Aug. 7, 2006

Thread	Author	Time
Querying constraints?	Lexington Luthor	15:38
Change of data type	Judith	17:38
Re: viewing the description of tables from python DB-API	George Young	19:20
Re: Change of data type	jason nordwick	20:43
Re: Change of data type	Kumar Dev	20:45

Aug. 8, 2006

Thread	Author	Time
Re: Change of data type	Roman Neuhauser	11:51
Query response time	Jonathan Sinclair	12:25
Re: Query response time	Chris Mair	12:48
Re: Query response time	Richard Broersma Jr	12:53
Function Temp Table Woes	Chad Voelker	17:24
date arithmetic	chrisj	21:27

Aug. 9, 2006

Thread	Author	Time
Re: Function Temp Table Woes	Michael Fuhr	02:12
Re: Query response time	Roman Neuhauser	17:24

Aug. 10, 2006

Thread	Author	Time
PL/pgSQL and PHP 5	PostgreSQL Admin	02:36
Re: PL/pgSQL and PHP 5	John DeSoi	03:24
Re: [SQL] PL/pgSQL and PHP 5	Tom Lane	03:40
Re: PL/pgSQL and PHP 5	PostgreSQL Admin	03:42
Re: [SQL] PL/pgSQL and PHP 5	PostgreSQL Admin	03:52
Re: [SQL] PL/pgSQL and PHP 5 - thanks	PostgreSQL Admin	04:01
Re: PL/pgSQL and PHP 5	John DeSoi	06:12
Re: Function Temp Table Woes	Chad Voelker	11:52
Re: timestamp (MS SQLServer's rowversion) functionality	Andrew Hammond	13:28
Re: date arithmetic	Osvaldo Rosario Kussama	19:21
Re: Querying constraints?	Chris Mair	19:25
Re: Querying constraints?	Chris Mair	19:27
Re: Change of data type	Shoaib Mir	19:49
how do I check for lower case 📎	Juliann Meyer	20:32
Re: how do I check for lower case	Rodrigo De León	21:39
Re: how do I check for lower case	Daryl Richter	21:46
Re: how do I check for lower case	Scott Marlowe	21:57
Re: how do I check for lower case	Oisin Glynn	22:49
Breaking up a query	Saad Anis	22:53
Re:	Niklas Johansson	23:30

Aug. 11, 2006

Thread	Author	Time
sql error creating function	TJ O'Donnell	00:33
Re: sql error creating function	Christopher Browne	12:48
Re: Query response time	Jonathan Sinclair	13:58
Can't find which return type is incorrect.	Chris Lukenbill	14:45
The Right Way to manage schemas in SCM systems	Andrew Hammond	15:05
Re: Can't find which return type is incorrect.	codeWarrior	15:28
Re: Can't find which return type is incorrect.	Chris Lukenbill	15:49
Undo an update	Judith	17:26
Re: Undo an update	Rodrigo De León	17:41
Re: timestamp (MS SQLServer's rowversion) functionality	Aaron Bono	18:04
Re: timestamp (MS SQLServer's rowversion) functionality	Andrew Hammond	18:40

Aug. 12, 2006

Thread	Author	Time
Re: Undo an update	Markus Schaber	09:08
Re: to_dec()	Aaron Bono	15:57
Re: Breaking up a query	Aaron Bono	16:22

Aug. 13, 2006

Thread	Author	Time
Re: Breaking up a query	Andrew Sullivan	14:43
Using bitmap index scans-more efficient	Kyle Bateman	17:46

Aug. 14, 2006

Thread	Author	Time
Re: Using bitmap index scans-more efficient	Florian Weimer	06:40
SQLMAP IBATIS insert values from web forms to a money type column	Emi Lu	13:49
Re: SQLMAP IBATIS insert values from web forms to a money type column	Andrew Sullivan	14:34
Multiple DB join	Sumeet Ambre	21:26
Re: Multiple DB join	Shoaib Mir	22:04

Aug. 15, 2006

Thread	Author	Time
Re: Using bitmap index scans-more efficient	Kyle Bateman	01:06
Re: Using bitmap index scans-more efficient	Tom Lane	01:53
Re: Multiple DB join	Andrew Sullivan	10:36
Re: Multiple DB join	Michael Fuhr	11:38
Re: Multiple DB join	Jorge Godoy	12:01
Re: Undo an update	Kis János Tamás	12:20
Re: Multiple DB join	Andrew Sullivan	13:18
Re: Multiple DB join	Jorge Godoy	13:25
Re: Query response time	Scott Marlowe	13:49
Re: Multiple DB join	Sumeet Ambre	14:11
Re: Breaking up a query	Scott Marlowe	14:16
Re: Multiple DB join	Andrew Sullivan	14:17
Re: Multiple DB join	Andrew Sullivan	14:17
Re: Multiple DB join	Sumeet	14:35
Re: Multiple DB join	Andrew Sullivan	14:45
Re: The Right Way to manage schemas in SCM systems	Aaron Bono	19:18
Re: Using bitmap index scans-more efficient	Kyle Bateman	21:58
Re: Using bitmap index scans-more efficient	Kyle Bateman	23:15

Aug. 16, 2006

Thread	Author	Time
Re: Undo an update	Markus Schaber	08:41
problem with sequence.....	Penchalaiah P.	11:31
Re: problem with sequence.....	Andrew Sullivan	14:17
Re: Undo an update	Rodrigo De León	15:28
OT: OpenDatabase Model ?	Jesper K. Pedersen	16:12
Re: Using bitmap index scans-more efficient	Tom Lane	16:58
DB creation script questions	Jon Horsman	18:44
Re: OT: OpenDatabase Model ?	Andrew Sullivan	19:07
Re: DB creation script questions	Andrew Sullivan	19:10
Re: OT: OpenDatabase Model ?	Jesper K. Pedersen	20:03
Re: Using bitmap index scans-more efficient	Kyle Bateman	20:46
Re: Using bitmap index scans-more efficient	Tom Lane	21:46

Aug. 17, 2006

Thread	Author	Time
Help with optional parameters	Rob Tester	03:39
Re: Help with optional parameters	Michael Fuhr	05:21
Re: OT: OpenDatabase Model ?	Andrew Sullivan	10:26
Re: Help with optional parameters	MaXX	12:54
NULL becomes default	Julian Scarfe	18:11
Re: NULL becomes default	Sumeet	18:22
About DBlink	Sumeet	20:37
Re: About DBlink	Michael Fuhr	20:59
Re: About DBlink	Sumeet	21:14
Re: About DBlink	Chris Mair	21:25
Re: About DBlink	Michael Fuhr	23:46

Aug. 18, 2006

Thread	Author	Time
Re: Help with optional parameters	Rob Tester	01:57
Re: Multiple DB join	Sumeet	15:07
Re: Multiple DB join	Andrew Sullivan	15:20
trigger needs to check in multiple tables.	Jacobo García	17:17

Aug. 19, 2006

Thread	Author	Time
Re: trigger needs to check in multiple tables.	Michael Fuhr	01:01
Re: NULL becomes default	Markus Schaber	07:51

Aug. 20, 2006

Thread	Author	Time
Re: NULL becomes default	Julian Scarfe	10:34

Aug. 21, 2006

Thread	Author	Time
Re: NULL becomes default	Andrew Sullivan	10:27
Triggers	Ezequias Rodrigues da Rocha	12:03
Re: Triggers	Kaloyan Iliev	12:19

Aug. 22, 2006

Thread	Author	Time
Re: Triggers	Kis János Tamás	06:34
to get DD-MM-YYYY format of data	Penchalaiah P.	13:16
Re: to get DD-MM-YYYY format of data	Alvaro Herrera	13:27
Re: to get DD-MM-YYYY format of data	Michael Fuhr	13:27
joining VIEWs	Brian Cox	16:40
Re: joining VIEWs	Stephan Szabo	16:59

Aug. 23, 2006

Thread	Author	Time
SQL92 compliance	Daniel CAUNE	01:40
error with mor than 1 sub-select	chrisj	01:47
Re: SQL92 compliance	Michael Glaesemann	01:54
Re: error with mor than 1 sub-select	Osvaldo Kussama	02:03
Re: error with mor than 1 sub-select	Michael Fuhr	02:06
Re: error with mor than 1 sub-select	chrisj	02:26
Re: error with mor than 1 sub-select	Erik Jones	14:57
Re: SQL92 compliance	Peter Eisentraut	16:11
Re: SQL92 compliance	Tom Lane	17:40
The length of the sql query	Emi Lu	17:53
Re: SQL92 compliance	Scott Marlowe	18:28
All columns from table in a joined query	MHahn	19:14
Deleting Functions	Scott Petersen	19:29
Re: All columns from table in a joined query	Sumeet	19:44
Re: Deleting Functions	Jim Buttafuoco	19:56
Re: All columns from table in a joined query	Tom Lane	21:26
Re: Deleting Functions	Tom Lane	21:34

Aug. 24, 2006

Thread	Author	Time
Re: SQL92 compliance	Peter Eisentraut	06:42
Re: SQL92 compliance	Peter Eisentraut	06:43
Re: The length of the sql query	Emi Lu	12:58
Re: The length of the sql query	Tom Lane	14:34
Importing data from csv	Sumeet	14:47
double precision vs. numeric	Aarni Ruuhimäki	16:36
Re: double precision vs. numeric	Peter Eisentraut	16:51
Function to retrieve the Id column	Ezequias Rodrigues da Rocha	17:07
Re: double precision vs. numeric	Michael Fuhr	17:24
Re: double precision vs. numeric	Tom Lane	17:29
Re: Function to retrieve the Id column	Michael Fuhr	18:13
Re: Deleting Functions	Scott Petersen	18:35
Performance Problem with sub-select using array	Travis Whitton	19:01
Lock Problem	André José Guergolet	20:27
Re: Lock Problem	Andrew Sullivan	20:52
RES: Lock Problem	André José Guergolet	21:12
Re: RES: Lock Problem	Scott Marlowe	21:19
Re: Importing data from csv	Phillip Smith	23:16
Re: Importing data from csv	Scot P. Floess	23:57
Re: Importing data from csv	Scot P. Floess	23:59

Aug. 25, 2006

Thread	Author	Time
Re: Importing data from csv	Phillip Smith	00:04
Re: Importing data from csv	Scot P. Floess	00:19
Re: RES: Lock Problem	Christopher Browne	03:00
Re: RES: Lock Problem	Tom Lane	04:29
Re: double precision vs. numeric	Aarni Ruuhimäki	05:12
Re: Importing data from csv	Michael Fuhr	06:06

Browse Archives

Prev | Next