pgsql-sql - April 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
Jump to day: 1 2 3 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 1, 2006

Thread Author Time
query; check for zero and floats vince 06:03
Re: query; check for zero and floats Tom Lane 06:32
Re: query; check for zero and floats Joe Conway 06:34
encryption/decryption AKHILESH GUPTA 10:55
Re: encryption/decryption chris smith 11:07
Re: encryption/decryption Nirmalya Lahiri 15:08

April 2, 2006

Thread Author Time
cross tables, SELECT expressions, and GROUP BY problem Ross Johnson 06:43
Re: cross tables, SELECT expressions, and GROUP BY problem Ross Johnson 08:00
Re: cross tables, SELECT expressions, and GROUP BY problem Ross Johnson 12:15

April 3, 2006

Thread Author Time
References NULL field Paul M Foster 03:43
Re: References NULL field Michael Fuhr 03:57
Re: group by function, make SQL cleaner? Bryce Nesbitt 21:58

April 4, 2006

Thread Author Time
Special meaning of NL string Vellinga, Fred 08:40
Re: have you feel anything when you read this ? Eugene E. 10:30
Re: have you feel anything when you read this ? Michael Glaesemann 11:05
Re: have you feel anything when you read this ? Stephan Szabo 14:21

April 5, 2006

Thread Author Time
query to return hourly snapshot Richard Broersma Jr 00:58
Re: query to return hourly snapshot Michael Fuhr 02:49
Re: query to return hourly snapshot Richard Broersma Jr 04:37
Re: have you feel anything when you read this ? Eugene E. 06:34
GROUP BY issue Jure Kodzoman (Dhimahi) 11:23
Re: have you feel anything when you read this ? Stephan Szabo 14:36
SELECT composite type Michael Burke 15:57
IF statement in Select Renato Cramer 16:45
Re: IF statement in Select William Leite Araújo 17:04
Reverse Index ... how to ... Marc G. Fournier 18:14
Re: Reverse Index ... how to ... Oleg Bartunov 18:20
Re: Reverse Index ... how to ... Tom Lane 19:06
Re: Reverse Index ... how to ... Marc G. Fournier 19:14
Re: SELECT composite type Niklas Johansson 20:31
problem comparing strings when different cluster / database encoding Tomas Vondra 22:29
Re: SELECT composite type Tom Lane 22:29
Re: problem comparing strings when different cluster / database encoding Tom Lane 22:39
Re: problem comparing strings when different cluster / database encoding Alvaro Herrera 23:03

April 6, 2006

Thread Author Time
Re: have you feel anything when you read this ? Eugene E. 05:07
Re: have you feel anything when you read this ? Stephan Szabo 06:24
Re: have you feel anything when you read this ? Eugene E. 07:18
pgcrypto-crypt AKHILESH GUPTA 08:23
Re: pgcrypto-crypt chris smith 08:53
Re: SELECT composite type Markus Schaber 09:28
Re: have you feel anything when you read this ? Stephan Szabo 11:52
Re: have you feel anything when you read this ? Stephan Szabo 12:33
Re: have you feel anything when you read this ? Eugene E. 12:33
Re: have you feel anything when you read this ? Markus Schaber 12:39
Re: have you feel anything when you read this ? Stephan Szabo 12:42
Re: SELECT composite type Michael Burke 12:45
Re: have you feel anything when you read this ? Markus Schaber 12:47
Re: have you feel anything when you read this ? Eugene E. 13:20
Re: pgcrypto-crypt Guy Fraser 18:23
Re: pgcrypto-crypt Owen Jacobson 18:31
Query from shell Judith 18:37
Re: Query from shell Owen Jacobson 21:37
Re: Query from shell Bricklen Anderson 21:39
Re: Query from shell Terry Lee Tucker 21:40
Re: Query from shell kevin.kempter 21:43
Re: pgcrypto-crypt Chris 22:24
Re: Query from shell Jim Buttafuoco 22:56

April 7, 2006

Thread Author Time
Modeling trees with Nested Sets and Nested Intervals Daniel Browning 07:28
[ocpfree] For my direct Client Looking for Mainframe const urgently Sachin 18:55
How to copy data between joined columns? Bryce Nesbitt 20:32
Re: How to copy data between joined columns? Scott Marlowe 20:34
Joins involving functions Jeff Boes 21:01
Re: How to copy data between joined columns? Bryce Nesbitt 21:36
Re: How to copy data between joined columns? Tom Lane 21:54
Re: How to copy data between joined columns? 📎 Bryce Nesbitt 22:24

April 8, 2006

Thread Author Time
Returning a set from an function Keith Hutchison 21:10
Re: Returning a set from an function Tom Lane 21:46

April 10, 2006

Thread Author Time
Re: Modeling trees with Nested Sets and Nested Intervals Michael Glaesemann 01:14
slow 'IN' clause FavoYang 03:44
how to use recursion to find end nodes of a tree mike 15:09
Re: Returning a set from an function codeWarrior 15:10
Re: how to use recursion to find end nodes of a tree Yasir Malik 16:12
Re: have you feel anything when you read this ? Markus Schaber 16:31
concatenation with a null column (using ||) nulls the result? Neil Harkins 21:36
Re: concatenation with a null column (using ||) nulls the result? Tom Lane 21:47
Re: concatenation with a null column (using ||) nulls the result? Alvaro Herrera 21:55
Re: concatenation with a null column (using ||) nulls the result? Terry Lee Tucker 22:03
Re: concatenation with a null column (using ||) nulls the Ross Johnson 22:52
Re: how to use recursion to find end nodes of a tree Ross Johnson 23:57

April 11, 2006

Thread Author Time
global variables in plpgsql? dave.bath 01:17
Re: Special meaning of NL string Tom Lane 02:57
Re: global variables in plpgsql? John DeSoi 05:15
Please help with a query.. Timo Tuomi 09:34
Re: Joins involving functions Markus Schaber 11:42
Re: how to use recursion to find end nodes of a tree mike 18:00
Re: slow 'IN' clause Bruno Wolff III 20:21

April 12, 2006

Thread Author Time
SQL help (Informix outer to EnterpriseDB outer) gurkan 18:45
SQL help (Informix outer to EnterpriseDB outer) gurkan 18:49
Re: SQL help (Informix outer to EnterpriseDB outer) kevin 19:30
Re: SQL help (Informix outer to EnterpriseDB outer) kevin.kempter 19:33

April 13, 2006

Thread Author Time
trigger to enforce FK with nulls? George Young 01:11
Re: trigger to enforce FK with nulls? Alvaro Herrera 01:22
Re: trigger to enforce FK with nulls? Stephan Szabo 01:26
Truncate and Foreign Key References question Gregory S. Williamson 02:43
Re: Special meaning of NL string Vellinga, Fred 06:23
how to solve this problem ivan marchesini 13:18
Re: how to solve this problem Richard Broersma Jr 13:51
Re: how to solve this problem ivan marchesini 13:56
on select rule Sergey Levchenko 15:46
Re: how to solve this problem Steve Crawford 18:34
Re: on select rule A. Kretschmer 21:40

April 14, 2006

Thread Author Time
Simple plpgsql question Todd Kennedy 03:38
Re: on select rule Sergey Levchenko 07:00
Re: on select rule Andreas Kretschmer 07:52
Re: Simple plpgsql question Terry Lee Tucker 09:03
Re: Simple plpgsql question Volkan YAZICI 09:13
Kernel 2.4->2.6 upgrade results in PANIC: could not locate a valid checkpoint record Achilleus Mantzios 10:26
Re: Kernel 2.4->2.6 upgrade results in PANIC: could not locate a Achilleus Mantzios 11:27
Re: how to solve this problem ivan marchesini 15:40

April 15, 2006

Thread Author Time
Re: how to solve this problem Luckys 09:56

April 17, 2006

Thread Author Time
Re: Please help with a query.. Bruno Wolff III 19:59

April 18, 2006

Thread Author Time
Re: [JDBC] Thoughts on a Isolation/Security problem. Markus Schaber 09:58
Re: [SQL] Thoughts on a Isolation/Security problem. Luckys 09:58
Re: [SQL] Thoughts on a Isolation/Security problem. Andy Shellam 10:06
Re: [JDBC] Thoughts on a Isolation/Security problem. Markus Schaber 10:41
Thoughts on a Isolation/Security problem. Achilleus Mantzios 10:44
Re: [JDBC] Thoughts on a Isolation/Security problem. Achilleus Mantzios 11:26
Re: [SQL] Thoughts on a Isolation/Security problem. Achilleus Mantzios 11:32
Migrating a Database to a new tablespace Markus Schaber 12:05
Looking for some help with cascading updates... Mark True 18:19
Re: [JDBC] [SQL] Thoughts on a Isolation/Security problem. Mark Lewis 18:24
Re: Looking for some help with cascading updates... Andreas Kretschmer 18:31
create temp table in rule Ron Peterson 18:42
Re: Looking for some help with cascading updates... Mark True 18:44
Re: Looking for some help with cascading updates... Andreas Kretschmer 18:49
Re: Looking for some help with cascading updates... Mark True 19:08
Re: Looking for some help with cascading updates... Andreas Kretschmer 19:21
Re: Looking for some help with cascading updates... Tom Lane 19:49
Re: create temp table in rule Tom Lane 19:53
Complex Informix OUTER gurkan 20:39

April 19, 2006

Thread Author Time
Primary key reference count Wiebe Cazemier 12:01
Re: Primary key reference count A. Kretschmer 13:09
Re: Primary key reference count Wiebe Cazemier 13:33
Re: Primary key reference count Wiebe Cazemier 15:00
Re: Primary key reference count Wiebe Cazemier 15:47
Re: Primary key reference count Volkan YAZICI 17:21

April 20, 2006

Thread Author Time
Field length ?? Louise Catherine 03:32
Re: Programatically Backup Database Using Visual Basic Josh Berkus 04:31
Re: Field length ?? Louise Catherine 06:08
ask syntax sql to get length of field Mariya Yuniarti 07:37
Re: Field length ?? Markus Schaber 09:16
Programatically Backup Database Using Visual Basic Christian Paul B. Cosinas 11:42
Re: Moving around in a SQL database Florian Reiser 12:35
At time zone madness! John Goss 13:31
Re: Field length ?? Tom Lane 14:27
Re: Field length ?? Frank Bax 15:21
Re: ask syntax sql to get length of field Bruno Wolff III 15:23
Re: Field length ?? Markus Schaber 15:36
Re: Field length ?? Tom Lane 15:44
Re: At time zone madness! Tom Lane 16:20

April 21, 2006

Thread Author Time
Re: Moving around in a SQL database Florian Reiser 07:00
Porting application with rules and triggers from PG 7.4.x to 8.1.3 Andreas Haumer 11:58
Re: Porting application with rules and triggers from PG 7.4.x to 8.1.3 Tom Lane 14:38
find all tables with a specific column name? Jeff Frost 16:29
Re: find all tables with a specific column name? Bruno Wolff III 18:03
Re: find all tables with a specific column name? Jeff Frost 18:30
Re: find all tables with a specific column name? George Young 18:31
Re: Porting application with rules and triggers from PG 7.4.x Bruce Momjian 21:31

April 22, 2006

Thread Author Time
Re: Moving around in a SQL database WillemF 08:47
Re: find all tables with a specific column name? Ben K. 21:37

April 23, 2006

Thread Author Time
date array A. R. Van Hook 12:55
Re: Primary key reference count Wiebe Cazemier 15:27
Re: date array Bruno Wolff III 16:36

April 24, 2006

Thread Author Time
Re: date array Bruno Wolff III 03:37
Re: Migrating a Database to a new tablespace Markus Schaber 10:05
Re: Migrating a Database to a new tablespace Markus Schaber 10:33
Re: Migrating a Database to a new tablespace Markus Schaber 11:34
"could not open file" issue Daniel Caune 16:17
Re: "could not open file" issue Andrew Sullivan 19:02
Re: "could not open file" issue Alvaro Herrera 19:21
Re: "could not open file" issue Daniel Caune 19:44
Re: "could not open file" issue Alvaro Herrera 20:35
Re: date array A. R. Van Hook 20:37
Re: "could not open file" issue Daniel Caune 20:38
Re: "could not open file" issue Daniel Caune 21:02
Re: "could not open file" issue Alvaro Herrera 21:40

April 25, 2006

Thread Author Time
Re: Migrating a Database to a new tablespace Jim C. Nasby 00:15
SELECTing into usertype, how to do it? Mario Splivalo 12:03
Re: SELECTing into usertype, how to do it? A. Kretschmer 12:21
Re: SELECTing into usertype, how to do it? Mario Splivalo 12:25
Re: SELECTing into usertype, how to do it? A. Kretschmer 12:42
Re: Migrating a Database to a new tablespace Markus Schaber 13:13
Re: Migrating a Database to a new tablespace Tom Lane 15:19
Re: Migrating a Database to a new tablespace Markus Schaber 16:50
Re: Migrating a Database to a new tablespace Tom Lane 18:13

April 26, 2006

Thread Author Time
Linked List Ray Madigan 02:50
Re: Migrating a Database to a new tablespace Markus Schaber 08:10
Re: LinkedList Scott Marlowe 15:59
LinkedList Ray Madigan 16:09
Re: Migrating a Database to a new tablespace Tom Lane 16:33
Re: Migrating a Database to a new tablespace Bruce Momjian 16:35
Re: LinkedList Ray Madigan 17:35

April 27, 2006

Thread Author Time
Re: Migrating a Database to a new tablespace Jim C. Nasby 05:38
Re: LinkedList Jim C. Nasby 05:46
Postgres 8.1 sequences and 'CALL'-syntax Schnabl, Sebastian 07:34
Re: LinkedList Neil Saunders 08:31
Re: Migrating a Database to a new tablespace Markus Schaber 08:53
Re: Migrating a Database to a new tablespace Markus Schaber 09:09
any one can help me how to get multiple rows in postgresql using arrays in functions Penchalaiah P. 11:27
Re: any one can help me how to get multiple rows in postgresql Richard Huxton 13:08

Browse Archives

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