pgsql-sql since 2002-10-18 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
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 28 29 30 31

Oct. 18, 2002

Thread Author Time
Re: Messy Casts, Is there a better way? Larry Rosenman 00:13
Can I create working trigger on view Акулов Александр 05:06
Re: Can I create working trigger on view Josh Berkus 05:27
Apparent referential integrity bug in PL/pgSQL Brian Blaha 07:15
UPDATE: Apparent referential integrity bug in PL/pgSQL Brian Blaha 07:19
Re: Locking that will delayed a SELECT Christoph Haller 07:33
Re: Locking that will delayed a SELECT Achilleus Mantzios 08:19
Re: Locking that will delayed a SELECT Achilleus Mantzios 08:32
Re: date wishy wishy 10:24
Re: Can I create working trigger on view Tom Lane 13:46
TRIGGERed INSERTS Martin Crundall 13:57
Re: Locking that will delayed a SELECT Tom Lane 13:57
Can I search for an array in csf? Vernon Wu 13:58
TRIGGERed INSERTS Martin Crundall 13:59
Re: TRIGGERed INSERTS Tom Lane 14:22
Re: Locking that will delayed a SELECT Ludwig Lim 15:02
Re: Apparent referential integrity bug in PL/pgSQL Stephan Szabo 15:05
isAutoIncrement and Postgres jm 16:18
Is there anyway to do this? Wei Weng 16:45
Re: TRIGGERed INSERTS Martin Crundall 16:59
Re: Is there anyway to do this? Ian Harding 17:10
Re: Is there anyway to do this? Bruno Wolff III 17:13
Re: error...what to do? Andrew Perrin 17:53
Re: error...what to do? Stephan Szabo 17:59
Re: functions that return a dataset or set of rows Bruce Momjian 18:01
Re: triggers Bruce Momjian 18:02
Re: Locking that will delayed a SELECT Tom Lane 18:03
Re: [SQL] foreign key, create table, and transactions Stephan Szabo 18:18
Re: date Jean-Luc Lachance 18:24
Re: [SQL] isAutoIncrement and Postgres Jean-Luc Lachance 18:24
join question Frank Morton 18:58
Re: date Tom Lane 19:19
Re: join question Stephan Szabo 19:31
Re: join question Jean-Luc Lachance 19:50
adding column with not null constraint Vivek Khera 20:12
Re: adding column with not null constraint mallah 21:57
Re: functions that return a dataset or set of rows Roberto Mello 22:29

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

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 28 29 30 31