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

Aug. 1, 2005

Thread Author Time
How to connect ORACLE database from Postgres function using plpgsql/pltclu? Dinesh Pandey 05:31
Re: bug in information_schema? Peter Eisentraut 08:42
Re: How to connect ORACLE database from Postgres function using plpgsql/pltclu? Dawid Kuroczko 10:35
Re: How to connect ORACLE database from Postgres function Sean Davis 11:16
Calling SQL functions that return sets Chris Mungall 21:43
Re: Calling SQL functions that return sets Tom Lane 23:57

Aug. 2, 2005

Thread Author Time
Re: Calling SQL functions that return sets Chris Mungall 01:14
Re: Calling SQL functions that return sets Tom Lane 01:48
Make year 01/01/0001 but leave timestamp alone Walker, Jed S 15:49
Re: Make year 01/01/0001 but leave timestamp alone Keith Worthington 16:14
Re: [NOVICE] Make year 01/01/0001 but leave timestamp alone daq 16:22
Re: Make year 01/01/0001 but leave timestamp alone John DeSoi 16:35
Breakdown results by month Henry Ortega 18:34
Re: Make year 01/01/0001 but leave timestamp alone Tom Lane 20:57

Aug. 3, 2005

Thread Author Time
Re: Trigger on select? Chris Travers 00:54
Trigger on select? Kyle Bateman 01:15
Re: Trigger on select? Karsten Hilbert 09:23
SQL error code -601 <ECPG_WARNING_QUERY_IGNORED> jason.ctr.alburger 12:53
Re: [NOVICE] SQL error code -601 <ECPG_WARNING_QUERY_IGNORED> daq 13:59
Re: Breakdown results by month codeWarrior 15:38
NEW and OLD as ROWS Craig Servin 17:52

Aug. 4, 2005

Thread Author Time
Re: NEW and OLD as ROWS Michael Fuhr 13:38
Re: Breakdown results by month Jeff Boes 13:42

Aug. 5, 2005

Thread Author Time
Make C file for create type Louise Catherine 08:51
'select where' using multiple columns. Rob Kirkbride 09:46
Re: 'select where' using multiple columns. Ian Johannesen 10:24
Re: 'select where' using multiple columns. daq 10:37
Re: 'select where' using multiple columns. Hélder M. Vieira 10:43
Re: Make C file for create type Richard Huxton 10:48
Re: 'select where' using multiple columns. Rob Kirkbride 10:49
sum but not grouped by? Henry Ortega 16:28
Re: sum but not grouped by? Mischa Sandberg 16:47
Re: sum but not grouped by? Henry Ortega 17:53
Re: sum but not grouped by? PFC 18:05

Aug. 6, 2005

Thread Author Time
how to use column name with Case-sensitive with out usig "" wisan watcharinporn 05:00
Re: [SQL] how to use column name with Case-sensitive with out usig Ragnar Hafstað 09:51
Caracter é Nicolas Cornu 20:58
Re: [SQL] Caracter é PFC 21:27
Re: Caracter é Frank Finner 21:34

Aug. 7, 2005

Thread Author Time
incorrect syntax for 'plpgsql' function to test boolean values Ferindo Middleton Jr 02:52
Re: incorrect syntax for 'plpgsql' function to test boolean values John DeSoi 03:18
Re: incorrect syntax for 'plpgsql' function to test boolean Ferindo Middleton Jr 05:25
Re: sum but not grouped by? Mischa Sandberg 06:55
Re: sum but not grouped by? Luca Rasconi Master 14:52

Aug. 8, 2005

Thread Author Time
trigger between to different database Haris Saybasili 18:41

Aug. 9, 2005

Thread Author Time
Re: [NOVICE] Suspend Referential Integrity? daq 13:58
unsubscribe Timothy Smith 22:31
Faster count(*)? Owen Jacobson 22:39
Re: **SPAM** Faster count(*)? dracula007 23:29

Aug. 10, 2005

Thread Author Time
Re: **SPAM** Faster count(*)? Tom Lane 02:49
insert into / select from / serial problem tgh002 03:03
Re: **SPAM** Faster count(*)? Michael Fuhr 03:29
Re: **SPAM** Faster count(*)? Andrew Sullivan 10:50
Re: **SPAM** Faster count(*)? Michael Fuhr 13:31
Re: Faster count(*)? Richard Huxton 14:04
sql function: using set as argument Akshay Mathur 14:30
Re: **SPAM** Faster count(*)? Owen Jacobson 16:27
Re: Breakdown results by month Bruno Wolff III 17:52
How to alias table columns in result? nori 22:45
Re: How to alias table columns in result? Mischa Sandberg 23:09

Aug. 11, 2005

Thread Author Time
Parentheses in FROM clause and evaluation order. dario.mx 00:42
Re: How to alias table columns in result? nori 09:48
Re: How to alias table columns in result? Nick Stone 09:56
Select problems Lucas Grijander 11:44
Re: How to alias table columns in result? nori 12:17
Re: How to alias table columns in result? Jeff Boes 12:22
How to encrypt a column Jeff Lu 17:16
Fwd: How to encrypt a column Jeff Lu 20:39
Re: Fwd: How to encrypt a column Owen Jacobson 20:50
Re: Fwd: How to encrypt a column Hélder M. Vieira 21:26
Re: Fwd: How to encrypt a column Jeff Lu 21:55
Re: Fwd: How to encrypt a column Owen Jacobson 22:09

Aug. 12, 2005

Thread Author Time
Re: Fwd: How to encrypt a column Bruno Wolff III 02:19
about subselect Louise Catherine 03:38
Re: about subselect Tom Lane 04:03
Re: about subselect Louise Catherine 04:17
Re: **SPAM** Faster count(*)? Keith Worthington 04:41
unsubscribe Jack Tiger 07:24
SQL Newbie Lane Van Ingen 15:09
catch an 'update where false' ? santiago 15:13
Re: catch an 'update where false' ? Alvaro Herrera 15:27
Encrypting in Postgresql-8.0 The One 15:42
Re: SQL Newbie Sean Davis 16:02
Left join pa on dal resulting in null Ilene 16:24
Re: SQL Newbie Nick Stone 17:57
Re: SQL Newbie Bruno Wolff III 18:04
Re: SQL Newbie Owen Jacobson 18:05
Re: SQL Newbie Bruno Wolff III 19:39

Aug. 13, 2005

Thread Author Time
Re: Fwd: How to encrypt a column Bruno Wolff III 00:04

Aug. 14, 2005

Thread Author Time
Re: catch an 'update where false' ? santiago 13:13

Aug. 15, 2005

Thread Author Time
Re: insert into / select from / serial problem Tom Lane 00:33
Re: trigger between to different database Michael Fuhr 03:12
Re: trigger between to different database Kenneth Gonsalves 03:15
Re: catch an 'update where false' ? Alvaro Herrera 03:22
Re: Select problems Richard Huxton 07:25
Re: insert into / select from / serial problem PFC 07:49
Re: catch an 'update where false' ? Richard Huxton 08:24
Tables are not being updated Properly through Trigger Venkatesh Krishnamurthy 12:37
Re: Parentheses in FROM clause and evaluation order. Stephan Szabo 14:02
Re: catch an 'update where false' ? Lane Van Ingen 15:00
PGSQL function for converting between arbitrary numeric bases? Simon Kinsella 15:48
Re: Parentheses in FROM clause and evaluation order. Dario Bahena Tapia 16:34
Re: sql function: using set as argument Thomas F. O'Connell 22:09
Problem with a Pettern Matching Check Sebastian Siewior 22:19
Re: Problem with a Pettern Matching Check Dmitri Bichko 22:37
Re: Problem with a Pettern Matching Check Michael Fuhr 22:42
Re: Problem with a Pettern Matching Check Andreas Seltenreich 22:43
Re: SUSPECT: RE: Re: Problem with a Pettern Matching Check Dmitri Bichko 22:44
Re: Problem with a Pettern Matching Check Sebastian Siewior 22:55
Re: Problem with a Pettern Matching Check Dmitri Bichko 23:08
SQL output Simon Law 23:55

Aug. 16, 2005

Thread Author Time
Re: Problem with a Pettern Matching Check Tom Lane 00:21
Re: SQL output Mischa Sandberg 00:26
Re: Problem with a Pettern Matching Check Michael Fuhr 00:43
Re: Problem with a Pettern Matching Check Tom Lane 01:14
Re: Parentheses in FROM clause and evaluation order. Stephan Szabo 01:48
Re: Parentheses in FROM clause and evaluation order. Tom Lane 02:02
Re: Parentheses in FROM clause and evaluation order. Dario Bahena Tapia 02:20
ARRAYs and INDEXes ... Marc G. Fournier 04:54
Re: ARRAYs and INDEXes ... Michael Fuhr 05:30
Re: sql function: using set as argument Akshay Mathur 05:53
What libraries need to be included in C program for encrypt and decrypt functions? The One 13:59
Re: ARRAYs and INDEXes ... Greg Stark 14:59
Re: What libraries need to be included in C program for encrypt and decrypt functions? Owen Jacobson 16:25
how to do a select * and decrypt a column at the same time? The One 19:53
Updateing pg_trigger and pg_constraint Craig Servin 20:18
Re: how to do a select * and decrypt a column at the same time? Bruno Wolff III 21:05
converting varchar to integer tv 23:34

Aug. 17, 2005

Thread Author Time
Re: converting varchar to integer Josh Berkus 00:05
pgsql-bugs Lee Hyun soon 05:29
Re: [despammed] converting varchar to integer Kretschmer Andreas 09:30
Re: converting varchar to integer Halley Pacheco de Oliveira 10:46
Re: [despammed] converting varchar to integer Frank Bax 16:46
Is it This Join Condition Do-Able? Lane Van Ingen 16:54
Re: Is it This Join Condition Do-Able? Dmitri Bichko 17:25
Re: [despammed] converting varchar to integer A. Kretschmer 17:40
Re: Is it This Join Condition Do-Able? Michael Fuhr 17:43
Re: Is it This Join Condition Do-Able? Jeremy Semeiks 17:44
Locating ( FKs ) References to a Primary Key Roger Motorola 19:06
Re: Is it This Join Condition Do-Able? Mischa Sandberg 19:31
Re: Locating ( FKs ) References to a Primary Key Dmitri Bichko 19:38
Re: Is it This Join Condition Do-Able? Dmitri Bichko 19:57
Re: Is it This Join Condition Do-Able? Ooh, ouch, blush Mischa Sandberg 20:55
Re: Is it This Join Condition Do-Able? Tom Lane 21:15

Aug. 18, 2005

Thread Author Time
How to secure PostgreSQL Data for distribute? Premsun Choltanwanich 02:56
Re: How to secure PostgreSQL Data for distribute? Pascual De Ruvo 03:32
Re: How to secure PostgreSQL Data for distribute? Kenneth Gonsalves 04:21
Re: How to secure PostgreSQL Data for distribute? Chris Travers 05:26
Re: Locating ( FKs ) References to a Primary Key Roger Tannous 05:58
Re: How to secure PostgreSQL Data for distribute? Christopher Browne 12:58
Re: [despammed] converting varchar to integer Halley Pacheco de Oliveira 14:25
A Table's Primary Key Listing Roger Tannous 14:36
Re: [GENERAL] pgsql-bugs Robert Treat 14:43
Re: A Table's Primary Key Listing Michael Fuhr 15:05
Re: A Table's Primary Key Listing daq 15:29
Re: A Table's Primary Key Listing D'Arcy J.M. Cain 16:18
Re: A Table's Primary Key Listing Roger Tannous 16:40
Re: A Table's Primary Key Listing Roger Tannous 16:42
Re: A Table's Primary Key Listing D'Arcy J.M. Cain 17:55
Re: A Table's Primary Key Listing Tom Lane 20:08
dates and selection Joel Fradkin 20:36
nevermind answered my own question by looking at my question what a DOH! Joel Fradkin 20:38
Re: A Table's Primary Key Listing Roger Tannous 20:39
Re: A Table's Primary Key Listing Roger Tannous 21:37
Re: How to secure PostgreSQL Data for distribute? Ferindo Middleton Jr 23:36

Aug. 19, 2005

Thread Author Time
SQL CASE Statements Lane Van Ingen 01:31
Re: SQL CASE Statements Dmitri Bichko 01:56
Re: dates and selection Josh Berkus 04:18
Re: Tables are not being updated Properly through Trigger A. Kretschmer 05:02
pl/PgSQL: Samples doing UPDATEs ... Marc G. Fournier 05:38
Re: pl/PgSQL: Samples doing UPDATEs ... daq 06:32
Re: pl/PgSQL: Samples doing UPDATEs ... Michael Fuhr 06:33
Re: A Table's Primary Key Listing Roger Tannous 08:18
[SOT] pypgsql function receiving dictionary as parameter? gherzig 13:13
Re: [SOT] pypgsql function receiving dictionary as parameter? Michael Fuhr 13:22
Re: [SOT] pypgsql function receiving dictionary as parameter? gherzig 13:34
Re: PGSQL function for converting between arbitrary numeric bases? Bruno Wolff III 14:59

Aug. 20, 2005

Thread Author Time
Re: SQL CASE Statements Halley Pacheco de Oliveira 11:25
Problem with self-made plpgsql-function / casting Moritz Bayer 14:54
Re: Problem with self-made plpgsql-function / casting Mark Dingee 15:45
Re: Problem with self-made plpgsql-function / casting Tom Lane 15:51
Re: Problem with self-made plpgsql-function / casting Moritz Bayer 16:00
Re: Problem with self-made plpgsql-function / casting Moritz Bayer 16:04
Data insert 📎 Postgres Admin 17:17
Re: Data insert Michael Fuhr 17:47
Unwanted nested dollar-quoted constants Bernard Henry Voynet 19:27

Aug. 21, 2005

Thread Author Time
nullif('','') on insert Matt L. 01:40
booleans and nulls Matt L. 02:25
returning inserted id Matt A. 19:56

Aug. 22, 2005

Thread Author Time
Numerical variables in pqsql statements Michael Schmidt 00:43
Re: A Table's Primary Key Listing Roger Tannous 10:23
Problem calling stored procedure neil.saunders 13:17
Re: SQL CASE Statements Lane Van Ingen 13:42
Re: Problem calling stored procedure Stephan Szabo 14:12
Re: Problem calling stored procedure Michael Fuhr 14:28
Re: A Table's Primary Key Listing Alvaro Herrera 15:12
PL/SQL Function: self-contained transaction? Marc G. Fournier 17:16
Re: PL/SQL Function: self-contained transaction? A. Kretschmer 18:15
Re: PL/SQL Function: self-contained transaction? Greg Stark 18:20
Why Doesn't SQL This Expression Work? Lane Van Ingen 19:50

Browse Archives

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