pgsql-sql since 2002-10-19 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

Oct. 19, 2002

Thread Author Time
Re: help! Horst Herb 00:22
Re: isAutoIncrement and Postgres jm 02:16
Re: isAutoIncrement and Postgres jm 02:17

Oct. 20, 2002

Thread Author Time
Restricting a VIEW. Terry Yapt 01:13
Re: indexing on char vs varchar Bruce Momjian 02:59
Re: adding column with not null constraint Johannes Lochmann 15:26

Oct. 21, 2002

Thread Author Time
Re: Restricting a VIEW. Ludwig Lim 02:51
Re: Restricting a VIEW. Terry Yapt 08:25
Re: Restricting a VIEW. Terry Yapt 08:26
Re: Can I search for an array in csf? Richard Huxton 10:13
Select table from other database Tiago Moitinho 10:54
Finding table constraints Jadcharla Srinivas 13:41
Re: Select table from other database Roberto Mello 14:21
Re: isAutoIncrement and Postgres Josh Berkus 15:46
Delete/Replace Bug in Functions? Josh Berkus 22:31
Re: Delete/Replace Bug in Functions? Tom Lane 22:44
Re: Delete/Replace Bug in Functions? Josh Berkus 22:50
Row Locking? eric soroos 23:09

Oct. 22, 2002

Thread Author Time
Fwd: Re: Can I search for an array in csf? Vernon Wu 02:55
Re: Fwd: Re: Can I search for an array in csf? Josh Berkus 03:02
Re: Fwd: Re: Can I search for an array in csf? Achilleus Mantzios 07:49
Re: Fwd: Re: Can I search for an array in csf? Achilleus Mantzios 08:03
'next' or similar in plpgsql Bhuvan A 10:13
Re: Locking that will delayed a SELECT Ludwig Lim 10:47
Re: Fwd: Re: Can I search for an array in csf? Vernon Wu 10:54
Re: Can I search for an array in csf? Vernon Wu 11:07
Re: Row Locking? Richard Huxton 12:51
7.2 time format funtion issue Nicholas Barthelemy 15:25
7.2 date/time format function problems Nicholas Barthelemy 15:39
Re: 7.2 date/time format function problems Ian Harding 15:47
using deferred on PK/FK relationships Dan Langille 15:58
Re: 7.2 date/time format function problems Stephan Szabo 16:03
Re: using deferred on PK/FK relationships Stephan Szabo 16:09
'fake' join and performance ? Peter Galbavy 16:10
Re: Can I search for an array in csf? Josh Berkus 16:16
Re: 'fake' join and performance ? Stephan Szabo 17:31
Re: 'fake' join and performance ? Tom Lane 17:39
Re: 'fake' join and performance ? Peter Galbavy 18:54
Joining tables from different relational databases with AlligatorDBC www.alligatorsql.com 22:24

Oct. 23, 2002

Thread Author Time
Multiple Databases peter 07:50
Re: sub-select with aggregate Tomasz Myrta 08:44
sub-select with aggregate Tomasz Myrta 10:07
Re: odbc drivers jasiek 10:14
Re: odbc drivers Tomasz Myrta 10:23
Re: sub-select with aggregate Stephan Szabo 13:02
Re: 7.2 time format funtion issue Tomasz Myrta 13:52
Re: sub-select with aggregate Tomasz Myrta 14:02
problem with a query 📎 Carlos Sousa 14:05
Re: sub-select with aggregate Stephan Szabo 14:25
Re: problem with a query Tomasz Myrta 14:37
Re: sub-select with aggregate Tomasz Myrta 14:53
Re: sub-select with aggregate Stephan Szabo 15:12
Re: sub-select with aggregate Stephan Szabo 15:27
Re: sub-select with aggregate Stephan Szabo 15:57
Re: Multiple Databases Josh Berkus 16:31
Re: Multiple Databases Joe Conway 16:36
odbc drivers andres javier garcia garcia 16:53
plpgsql cursors : dynamic or static? Ludwig Lim 17:21
Hairy question - transpose columns andres javier garcia garcia 17:56
Re: Hairy question - transpose columns Stephan Szabo 18:06
Re: Hairy question - transpose columns eric soroos 18:18
Re: plpgsql cursors : dynamic or static? Josh Berkus 18:21
Re: plpgsql cursors : dynamic or static? Tom Lane 18:56
Sum of Every Column Tom Haddon 20:17
Sum of Every Column Tom Haddon 20:17
Re: Sum of Every Column Jean-Luc Lachance 21:13
Re: Sum of Every Column Josh Berkus 21:15
Re: sub-select with aggregate Tomasz Myrta 23:19

Oct. 24, 2002

Thread Author Time
sub-select trouble: wrong SQL or PostgreSQL issue? patrick 02:44
Re: sub-select trouble: wrong SQL or PostgreSQL issue? Stephan Szabo 02:59
Re: sub-select trouble: wrong SQL or PostgreSQL issue? Tom Lane 03:28
Simulating a SELECT..FOR UPDATE to LOCK and SELECT statement Ludwig Lim 04:10
Re: Multiple Databases peter 06:42
Re: Sum of Every Column 📎 Achilleus Mantzios 07:36
Re: 'next' or similar in plpgsql Christoph Haller 07:56
grouping and first() peter 08:12
Basic question. andres javier garcia garcia 08:15
Re: sub-select with aggregate Tomasz Myrta 08:51
Re: Basic question. Tomasz Myrta 08:59
Re: Basic question. Tomasz Myrta 09:14
Re: sub-select trouble: wrong SQL or PostgreSQL issue? patrick 09:15
Re: sub-select with aggregate Tomasz Myrta 09:37
Re: sub-select with aggregate Tomasz Myrta 09:39
Problems with to_char(created, 'WW') Andreas Joseph Krogh 10:51
ORDER the result of a query by date andres javier garcia garcia 10:57
Re: ORDER the result of a query by date Henshall, Stuart - Design & Print 10:59
Re: Problems with to_char(created, 'WW') Karel Zak 11:08
Re: Problems with to_char(created, 'WW') Tomasz Myrta 11:19
Re: ORDER the result of a query by date Achilleus Mantzios 11:28
How can I retrieve an info about function arguments ? Zuev Dmitry 11:35
Re: Simulating a SELECT..FOR UPDATE to LOCK and SELECT statement Tom Lane 13:42
Help on creating a High Availability PostgreSQL solution? Charles H. Woloszynski 14:27
from postgres to oracle Carlos Sousa 15:01
Re: sub-select with aggregate Stephan Szabo 15:19
Re: from postgres to oracle Thomas Good 15:20
redirect query results to my (stdout) screen andres javier garcia garcia 15:49
Re: redirect query results to my (stdout) screen Achilleus Mantzios 16:14
Re: sub-select with aggregate Stephan Szabo 16:39
Re: sub-select with aggregate Tom Lane 20:32

Oct. 25, 2002

Thread Author Time
High Availability PostgreSQL solution? Charles H. Woloszynski 01:13
Re: Help on creating a High Availability PostgreSQL Tatsuo Ishii 01:26
if exists (select * from ... Christoph Haller 07:57
Upper / lower cases on table and column names Reiner Dassing 12:16
Re: Upper / lower cases on table and column names Stephan Szabo 12:48
Re: Upper / lower cases on table and column names Achilleus Mantzios 12:51
Foreign character struggles Tim Perdue 13:33
VACUUM and locking Denise Bossarte 14:36
Re: Foreign character struggles Tony Grant 14:36
Re: Foreign character struggles Tom Lane 14:37
Re: Foreign character struggles Tom Lane 14:49
Re: Foreign character struggles Roberto Mello 14:52
Re: grouping and first() Chad Thompson 15:06
Re: Foreign character struggles Tim Perdue 15:35
Re: Foreign character struggles Tom Lane 16:24
Re: Foreign character struggles Tim Perdue 16:50

Oct. 26, 2002

Thread Author Time
CoreReader John Ragan 03:32
multiple databases peter 05:15
Re: How can I retrieve an info about function arguments ? Bhuvan A 06:05
subscrip out of range peter 08:25
Re: Hairy question - transpose columns mark carew 20:14

Oct. 27, 2002

Thread Author Time
Re: datediff? Josh Berkus 18:23
Re: datediff? Josh Berkus 19:49

Oct. 28, 2002

Thread Author Time
Accumulated sums in SQL query Kabai Jzsef 08:13
Re: Accumulated sums in SQL query Christoph Haller 08:20
Re: Accumulated sums in SQL query Kabai Jzsef 09:07
Re: Accumulated sums in SQL query Christoph Haller 12:27
Re: multiple databases Roberto Mello 14:21
Re: CoreReader Roberto Mello 14:21
Re: CoreReader John Ragan 14:38
Re: Accumulated sums in SQL query Kabai Jzsef 14:55
Re: Accumulated sums in SQL query Marek Bartnikowski 14:57
Re: VACUUM and locking Tom Lane 18:39
psql history [email protected] 19:57
Re: subscrip out of range Chad Thompson 21:22

Oct. 29, 2002

Thread Author Time
BOOLEAN question Josh Berkus 01:06
Re: BOOLEAN question Stephan Szabo 01:26
Re: BOOLEAN question Josh Berkus 01:29
Re: BOOLEAN question Stephan Szabo 03:53
Creating Stored Procedures Philip Van Hoof 18:23
Re: BOOLEAN question Tom Lane 18:27
Re: [SQL] Creating Stored Procedures Stephan Szabo 18:36
Re: BOOLEAN question Josh Berkus 20:32
Re: BOOLEAN question Peter Eisentraut 22:19
Selecting * from the base table but getting the inheriteds columns James Adams 22:37

Oct. 30, 2002

Thread Author Time
Re: BOOLEAN question Bruno Wolff III 02:22
Database Design tool Viacheslav N Tararin 06:45
Re: Selecting * from the base table but getting the inheriteds Tomasz Myrta 08:05
Re: Creating Stored Procedures Kabai Jzsef 08:07
Re: Creating Stored Procedures Jonas Wouters 09:08
Re: Database Design tool Bhuvan A 09:15
Re: Selecting * from the base table but getting the inheriteds James Adams 09:25
Re: Creating Stored Procedures Adam Witney 09:42
Re: [SQL] Database Design tool Tomasz Myrta 09:44
Re: Database Design tool Diogo Biazus 13:37
Re: [SQL] Database Design tool Johannes Lochmann 14:35
Re: [SQL] Database Design tool Dan Hrabarchuk 15:30
Re: BOOLEAN question Jean-Luc Lachance 16:26
Re: BOOLEAN question Jean-Luc Lachance 16:38
unnecessary updates chester c young 16:42
Re: unnecessary updates Andrew Perrin 18:02
How do I get rid of these messages? Wei Weng 18:28
Re: [SQL] Database Design tool Kevin Old 20:42
Re: Database Design tool Wei Weng 23:07
Re: Database Design tool Josh Berkus 23:43
Re: Database Design tool Wei Weng 23:52
Re: Database Design tool Josh Berkus 23:56

Oct. 31, 2002

Thread Author Time
Re: Database Design tool Reinoud van Leeuwen 00:12
time limit of a database connection jack 06:44
Re: time limit of a database connection Achilleus Mantzios 08:14
Re: How do I get rid of these messages? Bhuvan A 08:58
Re: psql history Robert Treat 14:50
Returning a recordset and filling datatable in a .NET applicatio n Jonas Wouters 15:33
Re: [SQL] Returning a recordset and filling datatable in a .NET Achilleus Mantzios 16:07
How do you write this query? Wei Weng 18:21
Re: How do you write this query? Richard Huxton 19:09
Re: How do you write this query? Jean-Luc Lachance 20:38

Nov. 1, 2002

Thread Author Time
Re: How do you write this query? Achilleus Mantzios 07:51
7.2.3: tuple is too big (max 8136) pilsl 13:33
Re: 7.2.3: tuple is too big (max 8136) Doug McNaught 13:50
Different size in the DATA directory Maurício Sessue Otta 14:09
Re: Different size in the DATA directory Maurício Sessue Otta 14:25
FIFO Queue Problems Chris Gamache 14:56
Re: Different size in the DATA directory dima 15:22
Re: Different size in the DATA directory Stephan Szabo 15:32
Re: Different size in the DATA directory Tim Perdue 16:02
Re: FIFO Queue Problems Richard Huxton 16:20
Re: Selecting * from the base table but getting the inheriteds Ross J. Reedstrom 16:37
Re: FIFO Queue Problems Tom Lane 16:51
Re: FIFO Queue Problems Bruno Wolff III 16:54
HA PostgreSQL Charles H. Woloszynski 18:26
Re: FIFO Queue Problems Wei Weng 19:18
Re: FIFO Queue Problems Tom Lane 19:47
Re: FIFO Queue Problems Bruno Wolff III 19:56
Does this matter? Wei Weng 20:18
Re: Does this matter? Josh Berkus 20:23
Re: Does this matter? Wei Weng 20:52
Re: Does this matter? Philip Hallstrom 20:53
Re: Does this matter? Andrew Sullivan 21:10
Re: unnecessary updates Ross J. Reedstrom 21:27
select syntax question Wei Weng 21:33

Browse Archives

Prev | Next