pgsql-sql since 2006-01-23 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

Jan. 23, 2006

Thread Author Time
DBMirror.pl performance change 📎 Achilleus Mantzios 10:57
Re: select and as doubt Bruno Wolff III 16:44
pgadmin Mark Fenbers 18:29
Re: pgadmin Owen Jacobson 19:35
Re: pgadmin Tom Lane 19:37
Re: How to implement Microsoft Access boolean (YESNO) Greg Stark 20:53
Re: How to implement Microsoft Access boolean (YESNO) Tom Lane 21:02

Jan. 24, 2006

Thread Author Time
Re: How to implement Microsoft Access boolean (YESNO) Greg Stark 05:03
Re: non-equi self-join optimization Bruno Wolff III 09:04
Re: How to implement Microsoft Access boolean (YESNO) PFC 10:14
Re: How to implement Microsoft Access boolean (YESNO) Tom Lane 14:59
Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? codeWarrior 16:08

Jan. 25, 2006

Thread Author Time
Re: How to implement Microsoft Access boolean (YESNO) Bath, David 01:05
sorting by day of the week Joseph Shraibman 01:23
Re: sorting by day of the week Joseph Shraibman 02:39
Fw: stored procedures for complex SELECTs ipv 03:01
Re: sorting by day of the week ipv 03:14
hi all......................!! AKHILESH GUPTA 06:27
Re: hi all......................!! Tino Wildenhain 06:50
Re: [SQL] hi all......................!! Richard Huxton 09:24
Re: [SQL] hi all......................!! Markus Schaber 09:27
Changing the transaction isolation level within the stored procedure? Mario Splivalo 14:12
Re: Changing the transaction isolation level within the stored Markus Schaber 14:54
psql in the command line Aniko.Badzong 15:57
Re: psql in the command line Alvaro Herrera 16:05
Re: Changing the transaction isolation level within the stored procedure? Jaime Casanova 16:46
filtering after join andrew 17:27
Re: psql in the command line Owen Jacobson 17:43
Re: filtering after join Michael Fuhr 17:53
Re: filtering after join Peter Eisentraut 19:11
Re: filtering after join andrew 20:13

Jan. 26, 2006

Thread Author Time
Re: Changing the transaction isolation level within the Mario Splivalo 07:08
Re: Changing the transaction isolation level within the Mario Splivalo 07:11
Re: Changing the transaction isolation level within the Markus Schaber 08:41
Re: Changing the transaction isolation level within the stored Markus Schaber 09:42
Physical column size Paul Mackay 10:06
Re: filtering after join Peter Eisentraut 10:27
Re: filtering after join andrew 10:54
Re: Physical column size Mario Weilguni 11:22
Re: filtering after join Peter Eisentraut 11:22
Re: Changing the transaction isolation level within the stored Andrew Sullivan 11:39
question with times and intervals A. Kretschmer 11:58
Re: question with times and intervals Richard Huxton 12:09
Re: question with times and intervals Andreas Kretschmer 12:46
Re: Changing the transaction isolation level within the stored Markus Schaber 12:51
Re: filtering after join andrew 12:54
Re: Changing the transaction isolation level within the stored Stephan Szabo 15:28
Query optimization with X Y JOIN J 15:43
Re: Query optimization with X Y JOIN Craig A. James 16:12
Re: Query optimization with X Y JOIN J 16:25
Re: [PERFORM] Query optimization with X Y JOIN Jaime Casanova 16:33
Re: Query optimization with X Y JOIN Joshua D. Drake 16:34
Re: Changing the transaction isolation level within the stored Andrew Sullivan 16:39
Re: Query optimization with X Y JOIN Richard Huxton 16:47
Re: filtering after join Peter Eisentraut 16:59
[HELP] Defining a function as a procedure Daniel Caune 17:09
Re: Query optimization with X Y JOIN J 17:13
Re: [HELP] Defining a function as a procedure Tom Lane 18:02

Jan. 27, 2006

Thread Author Time
Question about check constraints Kashmira Patel (kupatel) 01:01
UPDATE with correlated aggregates Joe Abbate 03:17
Re: filtering after join andrew 09:10
Re: filtering after join andrew 09:17
Re: Changing the transaction isolation level within Mario Splivalo 09:20
REPOST:Memory Allocation error using pg_dump on 7.4 frank church 11:03
How to find a temporary table Emil Rachovsky 12:48
Re: How to find a temporary table Pandurangan R S 12:58
Re: How to find a temporary table Mario Splivalo 13:33
Re: filtering after join Tom Lane 14:55
Re: filtering after join andrew 15:21
Re: filtering after join andrew 16:32
Question about check constraints Kashmira Patel (kupatel) 23:06

Jan. 28, 2006

Thread Author Time
Re: Question about check constraints Michael Fuhr 00:40
Re: Question about check constraints Kashmira Patel (kupatel) 01:46
Re: Question about check constraints Stephan Szabo 05:24
Re: Question about check constraints Kashmira Patel (kupatel) 06:48

Jan. 29, 2006

Thread Author Time
Re: Function with default value? Tom Lane 15:47
Function with default value? Daniel CAUNE 20:15

Jan. 30, 2006

Thread Author Time
variable scooping ody quraviharto 02:01
Re: Function with default value? Daniel CAUNE 03:40
Re: variable scooping Michael Fuhr 04:24
regarding debugging? AKHILESH GUPTA 06:38

Jan. 31, 2006

Thread Author Time
Re: regarding debugging? Scott Ribe 04:38
CREATE VIEW form stored in database? Mario Splivalo 09:51
Re: CREATE VIEW form stored in database? Richard Huxton 12:30
Re: CREATE VIEW form stored in database? Mario Splivalo 13:53
Re: CREATE VIEW form stored in database? George Weaver 14:53
how is searchable email archive on Jacob Costello 16:10
Re: how is searchable email archive on Alvaro Herrera 17:53

Feb. 1, 2006

Thread Author Time
Re: how is searchable email archive on Achilleus Mantzios 08:33
UnixODBC-2.2.8-2.3.0 driver Philly Mandiza 10:11
executing dynamic commands christian.michels 15:26
Re: executing dynamic commands codeWarrior 15:45
CREATE INDEX with order clause Daniel Caune 15:46
Re: CREATE INDEX with order clause Tom Lane 16:16
Re: executing dynamic commands christian.michels 16:43
Re: executing dynamic commands Stephan Szabo 17:05
Does PostgreSQL support job? Daniel Caune 22:53
Re: Does PostgreSQL support job? Bruce Momjian 22:56
Re: Does PostgreSQL support job? Daniel Caune 22:59
Re: Does PostgreSQL support job? Owen Jacobson 22:59
Re: Does PostgreSQL support job? Andrew Sullivan 23:00
Re: Does PostgreSQL support job? Daniel Caune 23:25

Feb. 2, 2006

Thread Author Time
Re: Does PostgreSQL support job? Alvaro Herrera 00:28
Re: Does PostgreSQL support job? Daniel CAUNE 02:53
Function Dependency 📎 Padam J Singh 06:24
Re: Does PostgreSQL support job? Magnus Hagander 08:49
Re: executing dynamic commands christian.michels 08:49
Re: Does PostgreSQL support job? Markus Schaber 14:16
Re: Does PostgreSQL support job? Daniel Caune 14:19
Re: Changing the transaction isolation level within the stored Markus Schaber 14:19
Re: Does PostgreSQL support job? Markus Schaber 14:25
Re: Does PostgreSQL support job? Daniel Caune 15:21
Re: Does PostgreSQL support job? Markus Schaber 15:38
Re: Does PostgreSQL support job? Achilleus Mantzios 16:33
Re: Does PostgreSQL support job? Achilleus Mantzios 16:49
strange quoted csv behavior with COPY George Pavlov 18:51

Feb. 3, 2006

Thread Author Time
[No subject] padmanabha konkodi 05:27
Re: CREATE INDEX with order clause Ragnar 09:27
Help writing a piece of SQL Nigel Bishop 10:43
Re: Help writing a piece of SQL Richard Huxton 11:01
Re: Help writing a piece of SQL Nigel Bishop 11:10
Re: Help writing a piece of SQL Niklas Johansson 12:59
Re: Help writing a piece of SQL Nigel Bishop 13:06
Re: Help writing a piece of SQL Niklas Johansson 13:20
Re: regarding debugging? SunWuKung 20:27

Feb. 5, 2006

Thread Author Time
Re: UnixODBC-2.2.8-2.3.0 driver Tom Lane 00:58
new rule syntax? A. R. Van Hook 12:00
Re: new rule syntax? Milen A. Radev 13:10
Re: new rule syntax? A. Kretschmer 13:17
Re: new rule syntax? Jim Buttafuoco 16:20

Feb. 6, 2006

Thread Author Time
Re: Function Dependency Tony Wasson 02:18
Trigger on a column Josep Sanmartí 09:44
Re: new rule syntax? Richard Huxton 09:49
Re: Trigger on a column Josep Sanmartí 10:48
Re: Trigger on a column Richard Huxton 11:01
Re: Function Dependency Karsten Hilbert 11:29
no notnull values, invalid stats? Markus Schaber 11:58
Trigger efficiency Josep Sanmartí 12:48
Re: no notnull values, invalid stats? Alvaro Herrera 14:02
Re: no notnull values, invalid stats? Markus Schaber 14:32
Re: Trigger efficiency Craig Servin 15:14
Re: no notnull values, invalid stats? Michael Fuhr 17:35

Feb. 7, 2006

Thread Author Time
query superboy143 (sent by Nabble.com) 09:45
Re: query Richard Huxton 10:34
passing array to database function padmanabha konkodi 10:36
Re: passing array to database function Richard Huxton 10:52
Re: passing array to database function Achilleus Mantzios 12:11
problem referencing an attrib which is not unique Vic Rowan 13:45
Re: problem referencing an attrib which is not unique Richard Huxton 14:17
Re: problem referencing an attrib which is not unique Patrick JACQUOT 14:27
Re: problem referencing an attrib which is not unique Vic Rowan 15:14
Filtering data based on timestamp Panos Kassianidis 15:40
Re: Filtering data based on timestamp Richard Huxton 15:49
Re: executing dynamic commands codeWarrior 15:53
trecherous subselect needs warning? george young 17:01
Re: Filtering data based on timestamp Richard Huxton 17:03
Re: trecherous subselect needs warning? Tom Lane 17:45
Re: trecherous subselect needs warning? george young 19:17
Re: trecherous subselect needs warning? Tom Lane 19:39

Feb. 8, 2006

Thread Author Time
Delete with join -- deleting related table entries? Bryce Nesbitt 17:14
Re: Delete with join -- deleting related table entries? BigSmoke 17:25
Re: (NONE) BigSmoke 17:27
Re: Delete with join -- deleting related table entries? Owen Jacobson 17:32
Re: Delete with join -- deleting related table entries? Bryce Nesbitt 17:33
Re: Delete with join -- deleting related table entries? Owen Jacobson 17:35
Re: regarding debugging? BigSmoke 17:36
Re: Delete with join -- deleting related table entries? Bryce Nesbitt 17:41
Re: Delete with join -- deleting related table entries? Markus Schaber 17:55
Re: Delete with join -- deleting related table entries? Owen Jacobson 17:56
Re: Delete with join -- deleting related table entries? Bryce Nesbitt 18:11
Re: Delete with join -- deleting related table entries? Owen Jacobson 18:18
Non Matching Records in Two Tables Ken Hill 21:10
Re: Non Matching Records in Two Tables Frank Bax 21:27
Re: Non Matching Records in Two Tables Markus Schaber 21:31
Re: Non Matching Records in Two Tables Owen Jacobson 21:31
Re: Non Matching Records in Two Tables Ken Hill 22:13
Syntax for "IF" clause in SELECT pgsql 23:12
Re: Syntax for "IF" clause in SELECT Bricklen Anderson 23:20

Feb. 9, 2006

Thread Author Time
Column Index vs Record Insert Trade-off? Ken Hill 01:53
unique constraint instead of primary key? what disadvantage(ODBC usage)? george young 02:04
Re: Syntax for "IF" clause in SELECT Ken Hill 02:06
Re: unique constraint instead of primary key? what Ken Hill 02:34
Re: unique constraint instead of primary key? what george young 07:44
Re: Non Matching Records in Two Tables Patrick JACQUOT 08:59
Concatenate strings using GROUP BY Philippe Lang 09:35
Re: Concatenate strings using GROUP BY A. Kretschmer 09:52
Re: Column Index vs Record Insert Trade-off? Richard Huxton 10:25
Re: unique constraint instead of primary key? what Richard Huxton 10:33
Re: Syntax for "IF" clause in SELECT Andrew Sullivan 13:32
Re: Non Matching Records in Two Tables BigSmoke 16:13
Re: unique constraint instead of primary key? what disadvantage(ODBC usage)? BigSmoke 16:22
Change definition of a view Andreas Roth 17:11
Re: unique constraint instead of primary key? what disadvantage(ODBC usage)? Tom Lane 17:12
Re: Change definition of a view Keith Worthington 18:09
UNIQUE, btree index allows duplicate records, if some fields are null Bryce Nesbitt 19:38
Re: UNIQUE, btree index allows duplicate records, if some fields are null Tom Lane 19:59
Re: unique constraint instead of primary key? what george young 20:10
Re: unique constraint instead of primary key? what BigSmoke 20:41

Feb. 10, 2006

Thread Author Time
Re: query Bruno Wolff III 06:11
date superboy143 (sent by Nabble.com) 06:18

Browse Archives

Prev | Next