pgsql-sql - March 2004

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 2 3 4 5 7 8 9 10 11 12 13 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31

March 1, 2004

Thread Author Time
How to get Rows Count Abdul Wahab Dahalan 02:06
Re: User defined types -- Social Security number... Michael Chaney 03:17
Re: Postgres DB Michael Chaney 03:20
Re: How to get Rows Count Iain 03:58
Re: User defined types -- Social Security number... Christopher Browne 04:11
Re: PLSQL Question regarding multiple inserts V i s h a l Kashyap @ [Sai Hertz And Control Systems] 04:17
Re: Field list from table Denis 05:30
Re: returning a recordset from PLpg/SQL 📎 Terence Kearns 15:19
Re: returning a recordset from PLpg/SQL Stephan Szabo 15:31
Re: User defined types -- Social Security number... Dana Hudes 16:54
Re: returning a recordset from PLpg/SQL Tom Lane 17:10
Re: User defined types -- Social Security number... Steve Crawford 17:42
Re: returning a recordset from PLpg/SQL Joe Conway 18:45
Re: User defined types -- Social Security number... Michael Chaney 21:12
SYSDATE in PostgreSQL !? Louie Kwan 21:18
Re: User defined types -- Social Security number... Michael Chaney 21:18
select by groups Martin Marques 22:20
Re: select by groups Manuel Sugawara 22:32
Re: SYSDATE in PostgreSQL !? Oliver Elphick 22:57
Re: returning a recordset from PLpg/SQL Terence Kearns 23:57

March 2, 2004

Thread Author Time
Re: returning a recordset from PLpg/SQL Terence Kearns 00:53
Re: returning a recordset from PLpg/SQL Terence Kearns 03:59
scripts for converting postgres to oracle? Terence Kearns 04:42
What's wrong with my date/interval arithmetic? Wojtek 06:01
Re: What's wrong with my date/interval arithmetic? Tom Lane 06:25
Re: What's wrong with my date/interval arithmetic? Wojtek 07:00
Re: What's wrong with my date/interval arithmetic? Tom Lane 15:03
Re: User defined types -- Social Security number... Greg Patnude 16:23
Re: [PERFORM] Materialized View Summary Bruce Momjian 16:40
Re: [PERFORM] Materialized View Summary Robert Treat 16:54
Strings in UDFs Ryan Riehle 16:55
Re: Strings in UDFs Ryan Riehle 17:22
Re: User defined types -- Social Security number... Chris Browne 17:30

March 3, 2004

Thread Author Time
Re: User defined types -- Social Security number... Tom Hebbron 01:20
oracle decode() Andreas Schmitz 10:48
Re: oracle decode() Richard Huxton 12:51
Encoding bytea Achilleus Mantzios 13:12
Re: Encoding bytea Joe Conway 22:59

March 4, 2004

Thread Author Time
calling function William Anthony Lim 06:29
Re: calling function Tom Lane 06:40
Re: Encoding bytea Achilleus Mantzios 07:54
sub-select parameter problem Philippe Lang 11:20
Re: sub-select parameter problem Richard Huxton 11:51
Re: sub-select parameter problem Christoph Haller 12:53
How to avoid (stop) a endless loop in a trigger Rodrigo Sakai 14:54
Re: How to avoid (stop) a endless loop in a trigger Oliver Elphick 15:13
query optimization Charles Hauser 17:56
debugging query to put message in pg logfile? george young 20:32
Re: returning a recordset from PLpg/SQL Radu-Adrian Popescu 21:01
Re: query optimization Tom Lane 21:15
Re: debugging query to put message in pg logfile? Tom Lane 21:35

March 5, 2004

Thread Author Time
Re: debugging query to put message in pg logfile? george young 15:23
Re: query optimization Jonathan M. Gardner 16:28
Re: Triggers Jonathan M. Gardner 16:32
Re: VIEW on lookup table Jonathan M. Gardner 16:39
Read bytea column from table and convert into base64..... beyaNet Consultancy 23:59

March 7, 2004

Thread Author Time
Re: VIEW on lookup table JJ Gabor 13:40

March 8, 2004

Thread Author Time
designer tool connect to PostgreSQL azwa 02:13
Re: designer tool connect to PostgreSQL Yasir Malik 03:54
Re: Read bytea column from table and convert into base64..... Achilleus Mantzios 07:24
Re: designer tool connect to PostgreSQL Silke Trissl 08:00
Login information in system tables Daniel Doorduin 12:46
Re: Login information in system tables Radu-Adrian Popescu 12:49
Simple SQL question Daniel Henrique Alves Lima 14:10
Functional index and string concatenation Daniel Henrique Alves Lima 15:19
Re: Functional index and string concatenation Edmund Bacon 15:28
Re: Functional index and string concatenation Tom Lane 15:48
Trying to make efficient "all vendors who can provide all items" terry 16:02
Re: Functional index and string concatenation Daniel Henrique Alves Lima 16:02
Re: Functional index and string concatenation Richard Huxton 17:38
Re: Trying to make efficient "all vendors who can provide all items" terry 19:23
Re: Trying to make efficient "all vendors who can provide all items" Matt Chatterley 20:40
Re: Trying to make efficient "all vendors who can provide all items" terry 20:45

March 9, 2004

Thread Author Time
Re: Trying to make efficient "all vendors who can provide all items" Christopher Browne 03:20
Re: Simple SQL question Daniel Henrique Alves Lima 04:21
ANALYZE error David Witham 04:22
Re: ANALYZE error Tom Lane 04:55
Re: ANALYZE error Iain 05:15
Re: Simple SQL question Iain 05:28
Re: Simple SQL question Iain 05:37
Help to simplify sample query Daniel Henrique Alves Lima 05:41
Re: Simple SQL question Daniel Henrique Alves Lima 05:43
Re: Help to simplify sample query Tomasz Myrta 06:24
Re: Help to simplify sample query Tom Lane 06:27
Re: designer tool connect to PostgreSQL BenLaKnet 07:53
Re: Help to simplify sample query Daniel Henrique Alves Lima 12:51
Re: Help to simplify sample query Daniel Henrique Alves Lima 13:14
Re: Trying to make efficient "all vendors who can provide all items" terry 13:37
currval() without specifying the sequence name ow 13:50
Re: currval() without specifying the sequence name Achilleus Mantzios 14:10
Re: currval() without specifying the sequence name ow 14:53
Re: Trying to make efficient "all vendors who can provide all items" Michael Glaesemann 14:58
Re: currval() without specifying the sequence name Achilleus Mantzios 15:09
Re: currval() without specifying the sequence name Richard Huxton 15:14
Re: Dramatic slowdown of sql when placed in a function Jeff Boes 15:17
Re: currval() without specifying the sequence name Tom Lane 16:10
Re: currval() without specifying the sequence name ow 16:36
Re: Help to simplify sample query Daniel Henrique Alves Lima 20:13
Re: Help to simplify sample query Bruno Wolff III 20:18
Re: bytea or blobs? Richard Huxton 21:02
Re: Dramatic slowdown of sql when placed in a function Mike Moran 21:21
correlated multi-set update? Marty Scholes 21:48
Converting query to view - duplicate fields Richard Grosse 22:40
Re: correlated multi-set update? Stephan Szabo 23:14

March 10, 2004

Thread Author Time
Re: Converting query to view - duplicate fields Stephan Szabo 02:17
pg_hba.conf azwa 04:12
Re: correlated multi-set update? Bruno Wolff III 04:52
Re: pg_hba.conf azwa 05:39
Database reporting tool azwa 06:17
Re: Database reporting tool Jerome Alet 06:52
changing constraints David 12:27
Re: changing constraints Paul Thomas 13:07
Re: changing constraints Achilleus Mantzios 13:41
Re: changing constraints Richard Huxton 13:51
Break a Report in Run Time Jander Rebelo Luiz 14:29
Re: changing constraints David 15:57
randomized order in select? Enver ALTIN 16:48
Alter table David 16:58
Changing primary keys David 17:17
Re: Alter table scott.marlowe 17:55
Re: designer tool connect to PostgreSQL Robert Treat 18:18
Break a report in Run Time Jander 18:23
Re: randomized order in select? Bruno Wolff III 19:02
Re: randomized order in select? scott.marlowe 19:06
Inserting data in a table using sub-selects Andreas Joseph Krogh 19:52
Tsearch2 question: getting histogram of the vector elements Rajesh Kumar Mallah 19:54
Re: Inserting data in a table using sub-selects Stephan Szabo 20:49
Re: Inserting data in a table using sub-selects] Marty Scholes 20:56
Re: Changing primary keys Jonathan Gardner 22:06
Re: Break a report in Run Time Jonathan Gardner 22:09
Re: Inserting data in a table using sub-selects] Andreas Joseph Krogh 22:33
Re: Converting query to view - duplicate fields - solved Richard Grosse 22:51
About pg_dump Daniel Henrique Alves Lima 23:00
Re: randomized order in select? Enver ALTIN 23:15

March 11, 2004

Thread Author Time
Re: designer tool connect to PostgreSQL azwa 01:51
Re: randomized order in select? Iain 05:31
Re: randomized order in select? Tom Lane 06:40
Re: Tsearch2 question: getting histogram of the vector elements Oleg Bartunov 09:01
Re: About pg_dump Rute Solipa 15:01
Re: Tsearch2 question: getting histogram of the vector elements George Essig 15:56
Re: About pg_dump Tom Lane 16:03
Re: Tsearch2 question: getting histogram of the vector elements mallah 16:03
Re: Break a report in Run Time Jonathan M. Gardner 16:22
Re: randomized order in select? scott.marlowe 16:28
Re: designer tool connect to PostgreSQL scott.marlowe 17:14
trace facility beyaNet Consultancy 17:39
Re: Break a report in Run Time Jonathan Gardner 20:14
Re: About pg_dump Daniel Henrique Alves Lima 21:13
IMPORT TOOL Louie Kwan 21:17
Problems with tsearch2: ERROR: datumGetSize: Invalid typLen 0 postgres 21:58
Re: IMPORT TOOL Chris Browne 22:14

March 12, 2004

Thread Author Time
sqlloader features azwa 09:05
where not unique Gary Stainburn 13:02
Re: where not unique Daniel Henrique Alves Lima 13:54
Re: where not unique Paul Thomas 13:57
Re: where not unique Daniel Henrique Alves Lima 14:05
SQL query --- big question??? Andrei Bintintan 14:36
Re: sqlloader features Jeff Eckermann 14:55
Re: SQL query --- big question??? Richard Huxton 15:20
pg_dump backwards compat issues tomg 19:58

March 13, 2004

Thread Author Time
function returning resultset William Anthony Lim 02:47
Object-relational features Yasir Malik 17:30

March 15, 2004

Thread Author Time
Invalid Characters Raman 10:37
Re: Invalid Characters Paul Thomas 11:42
Re: Object-relational features John DeSoi 13:28
Re: Object-relational features Yasir Malik 14:06
Re: Object-relational features Bruno Wolff III 15:07
Re: Object-relational features Stephan Szabo 15:13

March 16, 2004

Thread Author Time
Import from Ms Excel Kumar 09:43
Re: Import from Ms Excel Andrew Sullivan 11:29
Re: Import from Ms Excel Achilleus Mantzios 11:42
Re: Import from Ms Excel Andrew Sullivan 11:47
Re: Import from Ms Excel Achilleus Mantzios 12:08
Re: Import from Ms Excel Dana Hudes 12:13
conversion of postgres database to oracle cristi 12:13
could not create shared memory segment: Invalid argument beyaNet Consultancy 12:31
flat file database to postgres noor 12:33
Re: could not create shared memory segment: Invalid argument Achilleus Mantzios 12:45
Re: could not create shared memory segment: Invalid argument Dana Hudes 13:02
Re: flat file database to postgres Frank Finner 13:30
Re: conversion of postgres database to oracle Andrew Sullivan 13:56
Can statement_timeout emulated NOWAIT? Luis P Caamano 13:58
Re: flat file database to postgres Tatsuo Ishii 14:04
Re: [SQL] could not create shared memory segment: Invalid argument Theodore Petrosky 14:31
Re: Can statement_timeout emulated NOWAIT? Tom Lane 15:48
Re: Can statement_timeout emulated NOWAIT? Bruce Momjian 15:56
Re: Import from Ms Excel Jeff Eckermann 16:13
Re: Can statement_timeout emulated NOWAIT? Luis P Caamano 16:33
working with unix timestamp Gary Stainburn 16:54
Re: working with unix timestamp Tom Lane 17:52
Re: working with unix timestamp Frank Finner 17:56

March 17, 2004

Thread Author Time
Line length in pl/pgsql function David Olbersen 00:47
Re: Line length in pl/pgsql function Tom Lane 05:35
Re: Line length in pl/pgsql function Richard Huxton 09:27
Re: working with unix timestamp Gary Stainburn 11:17
Re: Line length in pl/pgsql function 📎 David Olbersen 19:50
Re: Line length in pl/pgsql function David Olbersen 19:52
Re: Line length in pl/pgsql function Tom Lane 20:03
Re: Line length in pl/pgsql function David Olbersen 20:07
Re: Line length in pl/pgsql function David Olbersen 20:37

Browse Archives

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