pgsql-sql since 2006-03-22 00:00

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

March 22, 2006

Thread Author Time
Using a parameter in Interval Davidson, Robert 00:52
Re: Using a parameter in Interval Michael Glaesemann 00:56
Re: Using a parameter in Interval Owen Jacobson 00:57
Re: Using a parameter in Interval Stephan Szabo 01:03
Re: have you feel anything when you read this ? Bruno Wolff III 03:29
Re: Power cut and performance problem 📎 Aftab Alam 03:38
Re: Power cut and performance problem Aftab Alam 03:38
Re: Referential integrity broken (8.0.3), sub-select help Patrick JACQUOT 09:01
COPY tablename FROM and null values ivan marchesini 11:18
Re: COPY tablename FROM and null values Luckys 12:27
Re: COPY tablename FROM and null values JSP 12:33
Re: COPY tablename FROM and null values Achilleus Mantzios 13:29
Re: Using a parameter in Interval Davidson, Robert 14:49
Re: COPY tablename FROM and null values Tom Lane 14:52
How to optimize this query? Maciej Piekielniak 17:17
Re: How to optimize this query? Markus Bertheau 17:58
Re: How to optimize this query? Maciej Piekielniak 18:18
Re: How to optimize this query? Markus Bertheau 18:27
Re: How to optimize this query? Markus Bertheau 18:32
Re: How to optimize this query? Maciej Piekielniak 18:45
Re: How to optimize this query? Maciej Piekielniak 18:52
Re: How to optimize this query? Maciej Piekielniak 18:54
Re: How to optimize this query? Maciej Piekielniak 19:07
Re: How to optimize this query? Jeffrey Melloy 19:19
Re: How to optimize this query? Maciej Piekielniak 19:25
Re: How to optimize this query? Maciej Piekielniak 20:01
Function Parameters in GROUP BY clause cause errors Davidson, Robert 20:11
Custom type Daniel Caune 20:25
Re: Custom type Terry Lee Tucker 20:41
Re: Custom type Bryce Nesbitt 21:07
Re: Custom type Daniel Caune 21:10
Re: [SQL] Function Parameters in GROUP BY clause cause errors Tom Lane 21:53
OUT parameter Daniel Caune 22:34
Re: OUT parameter Owen Jacobson 22:39

March 23, 2006

Thread Author Time
Re: Function Parameters in GROUP BY clause cause errors Christian Paul B. Cosinas 01:33
Re: OUT parameter Tom Lane 02:47
Re: [SQL] Function Parameters in GROUP BY clause cause errors Tom Lane 04:27
Re: [SQL] Function Parameters in GROUP BY clause cause errors Davidson, Robert 13:30
Re: OUT parameter Owen Jacobson 17:12
Re: OUT parameter Daniel Caune 19:20
Expressing a result set as an array (and vice versa)? Don Maier 19:44

March 24, 2006

Thread Author Time
Nightly builds (was: [SQL] Function Parameters in GROUP BY clause cause errors) Jim C. Nasby 13:21
Re: Nightly builds Andrew Dunstan 14:32
Re: Nightly builds Jim C. Nasby 14:45
SQL Query Newbie Help Julie Robinson 16:24
Question about One to Many relationships Todd Kennedy 16:52
Re: Question about One to Many relationships D'Arcy J.M. Cain 17:01
Re: Question about One to Many relationships Milorad Poluga 17:22
Re: Question about One to Many relationships PFC 17:29
Re: Question about One to Many relationships Todd Kennedy 17:37
Re: SQL Query Newbie Help Julie Robinson 17:50
Re: Question about One to Many relationships Joe 18:34
Re: Question about One to Many relationships Todd Kennedy 18:36
Re: Question about One to Many relationships D'Arcy J.M. Cain 18:42
Re: Custom type george young 20:07
Find min and max values across two columns? Amos Hayes 20:19
generate_series to return row that doesn't exist in table... MaXX 20:30
Re: generate_series to return row that doesn't exist in Scott Marlowe 20:42
Re: Find min and max values across two columns? Rod Taylor 20:46
Re: generate_series to return row that doesn't exist in MaXX 20:54
Re: Custom type Tom Lane 20:58
Re: Find min and max values across two columns? Tom Lane 21:00
Re: Find min and max values across two columns? Rod Taylor 21:20
Re: Find min and max values across two columns? Tom Lane 21:20
Re: Find min and max values across two columns? Amos Hayes 21:34
Index on nullable column Daniel Caune 22:13
Re: SQL Query Newbie Help Stephan Szabo 22:29
Re: Expressing a result set as an array (and vice versa)? PFC 23:17
Re: Index on nullable column Tom Lane 23:48

March 25, 2006

Thread Author Time
regarding join AKHILESH GUPTA 06:36
Re: regarding join Andreas Kretschmer 07:45
Re: regarding join Martijn van Oosterhout 08:45
Re: regarding join Stefan Becker 10:57
Re: Index on nullable column Daniel CAUNE 12:38

March 26, 2006

Thread Author Time
Re: Expressing a result set as an array (and vice versa)? george young 03:11
Re: Expressing a result set as an array (and vice versa)? Volkan YAZICI 05:56
Bitfields always atomic? Other way to store attributes? Bryce Nesbitt 21:47

March 27, 2006

Thread Author Time
Problem using set-returning functions Markus Schaber 10:41
Re: [postgis-users] Problem using set-returning functions Markus Schaber 13:21
Re: Problem using set-returning functions John DeSoi 13:32
Re: functions in WHERE clause Markus Schaber 13:32
Re: Expressing a result set as an array (and vice versa)? Jim C. Nasby 13:48
Re: SQL Query Newbie Help Jim C. Nasby 13:49
Re: Question about One to Many relationships Jim C. Nasby 13:52
Re: Find min and max values across two columns? Jim C. Nasby 13:56
Re: Problem using set-returning functions Markus Schaber 14:00
Re: pgsql aggregate: conditional max Markus Schaber 14:14
Re: Permission to Select Markus Schaber 14:25
Re: [postgis-users] Problem using set-returning functions Markus Schaber 14:29
Re: Problem using set-returning functions John DeSoi 14:30
unique names in variables and columns in plsql functions Wiebe Cazemier 14:33
Re: unique names in variables and columns in plsql functions Jim C. Nasby 14:48
Re: pgsql2shp - Could not create dbf file Markus Schaber 14:51
Re: unique names in variables and columns in plsql functions Tom Lane 15:02
Re: unique names in variables and columns in plsql functions Jim C. Nasby 15:05
Re: Problem using set-returning functions Stephan Szabo 15:06
Re: Expressing a result set as an array (and vice versa)? PFC 15:12
Re: Problem using set-returning functions Markus Schaber 15:14
Re: Problem using set-returning functions Tom Lane 15:48
psqlODBC driver -- too many tables shown Bryce Nesbitt 19:09
Re: Bitfields always atomic? Other way to store attributes? Peter Eisentraut 19:13
Re: Bitfields always atomic? Other way to store attributes? Janning Vygen 19:20
Re: unique names in variables and columns in plsql functions Wiebe Cazemier 21:38
Re: unique names in variables and columns in plsql functions Wiebe Cazemier 21:39
cursor and for update Maciej Piekielniak 23:35

March 28, 2006

Thread Author Time
Re: cursor and for update Wiebe Cazemier 00:42
Re: Permission to Select Eugene E. 05:54
Proposed dbmirror change Achilleus Mantzios 08:16
Re: cursor and for update Maciej Piekielniak 09:13
Re: cursor and for update Wiebe Cazemier 09:59
Update question Fay Du 16:41
Re: Update question Markus Schaber 16:51
Re: Update question Gábriel Ákos 17:34
Re: Update question Fay Du 18:33
Re: Bitfields always atomic? Other way to store attributes? TJ O'Donnell 21:55
Re: Bitfields always atomic? Other way to store attributes? Owen Jacobson 21:59

March 29, 2006

Thread Author Time
Flight numbers data Achilleus Mantzios 08:17
Ugly group by problem Markus Schaber 13:40
Re: Ugly group by problem Markus Schaber 14:44
Re: Ugly group by problem Achilleus Mantzios 15:42
Re: [SQL] Flight numbers data Scott Marlowe 16:50
Getting more information about errorcodes such as when these error1 happen Emi Lu 17:05
Re: Flight numbers data Vivek Khera 18:16
Re: [SQL] Flight numbers data Simon Riggs 20:12
Re: [SQL] Flight numbers data Josh Rovero 20:56
Re: Ugly group by problem Niklas Johansson 23:49

March 30, 2006

Thread Author Time
results being col wise rather than row wise Hrishikesh Deshmukh 01:08
Re: results being col wise rather than row wise Stephan Szabo 01:23
Re: [SQL] Flight numbers data Achilleus Mantzios 08:41
Re: [SQL] Flight numbers data Achilleus Mantzios 08:46
Re: Ugly group by problem Achilleus Mantzios 10:20

March 31, 2006

Thread Author Time
Re: have you feel anything when you read this ? Eugene E. 06:17
Re: have you feel anything when you read this ? Stephan Szabo 16:47

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

Browse Archives

Prev | Next