pgsql-sql - July 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 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 1, 2006

Thread Author Time
Re: Alternative to Select in table check constraint Michael Glaesemann 00:27
Re: Alternative to Select in table check constraint Richard Broersma Jr 01:41
Re: Alternative to Select in table check constraint Tom Lane 04:11
Re: Alternative to Select in table check constraint Richard Broersma Jr 05:10
Re: [SQL] Doubt in stored procedure Jim C. Nasby 05:50
Re: Alternative to Select in table check constraint Erik Jones 12:54
Constraint UNIQUE on a column not case sensitive Daniel CAUNE 13:47
Re: Constraint UNIQUE on a column not case sensitive Michael Glaesemann 14:01
Re: Constraint UNIQUE on a column not case sensitive Jorge Godoy 14:04
Re: Constraint UNIQUE on a column not case sensitive Daniel CAUNE 15:48
Re: Alternative to Select in table check constraint Rod Taylor 17:06
Re: Alternative to Select in table check constraint Aaron Bono 20:36
Left join? Carlos H. Reimer 21:21
Re: Left join? Richard Broersma Jr 21:44

July 2, 2006

Thread Author Time
RES: Left join? Carlos H. Reimer 12:52
Can't drop table Hima Surapaneni 22:30

July 3, 2006

Thread Author Time
Re: Alternative to Select in table check constraint Richard Broersma Jr 01:50
Re: Alternative to Select in table check constraint Richard Broersma Jr 01:52
Re: join two tables with sharing some columns between two Phillip Smith 02:16
Re: Can't drop table Richard Broersma Jr 02:30
Re: Can't drop table Tom Lane 03:23
hi i need to connect database from my system to another system Penchalaiah P. 10:13
Re: graph plottin engines compatible with postgres Patrick Jacquot 10:31
Re: hi i need to connect database from my system to another system Richard Broersma Jr 11:58
Re: Fwd: Start up question about triggers Forums @ Existanze 12:20
Re: hi i need to connect database from my system to another system Richard Broersma Jr 12:26
Re: hi i need to connect database from my system to another Penchalaiah P. 12:46
Re: hi i need to connect database from my system to another Richard Broersma Jr 13:09
Local variable and column name conflict Daniel Caune 15:34
Re: Local variable and column name conflict Tom Lane 15:37
Re: join two tables with sharing some columns between two Thomas Beutin 15:54
Re: unique values of profile in the whole system Bruno Wolff III 16:06

July 4, 2006

Thread Author Time
i have a problem of privilages Penchalaiah P. 10:05
Re: i have a problem of privilages MJ Santhosh 12:17
Re: i have a problem of privilages Penchalaiah P. 12:23
Re: i have a problem of privilages MJ Santhosh 12:31
Re: i have a problem of privilages Richard Broersma Jr 14:51
Re: i have a problem of privilages Andreas Kretschmer 15:30
Re: SQL (Venn diagram type of logic) Aaron Bono 16:55
Null attributes Rodrigo Sakai 16:59

July 5, 2006

Thread Author Time
Foreign Key: what value? Davi Leal 15:19
Re: Foreign Key: what value? A. Kretschmer 15:34
Problem with array subscripts in plpgsql trigger function Erik Jones 16:52
Re: Problem with array subscripts in plpgsql trigger function Aaron Bono 17:36
Re: Problem with array subscripts in plpgsql trigger function Erik Jones 17:42
Re: Problem with array subscripts in plpgsql trigger function Aaron Bono 17:56
Re: "CASE" is not a variable Keith Worthington 18:08
Re: Problem with array subscripts in plpgsql trigger function Erik Jones 18:10
Re: Foreign Key: what value? -- currval() Davi Leal 22:07

July 6, 2006

Thread Author Time
week ending Keith Worthington 04:19
Re: week ending Rodrigo De Leon 07:00
Alternative to serial primary key David Clarke 10:16
Re: Alternative to serial primary key Andrew Sullivan 10:44
Re: Alternative to serial primary key Markus Schaber 10:46
Re: Alternative to serial primary key David Clarke 11:06
Re: Alternative to serial primary key Markus Schaber 11:10
Re: Alternative to serial primary key Andrew Sullivan 11:12
Re: Alternative to serial primary key Markus Schaber 11:28
Re: Alternative to serial primary key David Clarke 11:32
Re: Alternative to serial primary key Chris Browne 12:28
Re: Alternative to serial primary key Andrew Sullivan 12:50
Re: Alternative to serial primary key Andrew Sullivan 12:51
Re: Alternative to serial primary key Scott Marlowe 14:41
Re: week ending Aaron Bono 15:49
Re: Alternative to serial primary key Aaron Bono 16:02
Re: Alternative to serial primary key operationsengineer1 18:39
Re: Foreign Key: what value? operationsengineer1 18:46
Re: Foreign Key: what value? Aaron Bono 19:32
Re: Alternative to serial primary key David Clarke 20:30
Re: Alternative to serial primary key D'Arcy J.M. Cain 21:18
Re: Alternative to serial primary key Aaron Bono 21:43
Re: Alternative to serial primary key Sander Steffann 21:45
Re: Alternative to serial primary key Scott Marlowe 21:50
Re: Alternative to serial primary key Scott Marlowe 21:51

July 7, 2006

Thread Author Time
Re: Alternative to serial primary key operationsengineer1 05:25
Re: Alternative to serial primary key Aaron Bono 05:51
Select CASE Concatenation Phillip Smith 06:47
Select Maths Phillip Smith 06:53
Re: Alternative to serial primary key David Clarke 07:37
Re: Alternative to serial primary key David Clarke 08:07
Re: Select Maths Rodrigo De Leon 08:20
Re: Alternative to serial primary key Aaron Bono 08:32
Re: Select Maths Aaron Bono 08:36
Re: Select CASE Concatenation Aaron Bono 08:44
Re: Alternative to Select in table check constraint Andreas Joseph Krogh 09:47
Update from join Gary Stainburn 10:29
Re: Alternative to serial primary key Andrew Sullivan 11:18
Re: Alternative to serial primary key Andrew Sullivan 11:21
Re: Alternative to serial primary key D'Arcy J.M. Cain 11:33
Re: Update from join Gary Stainburn 11:39
Re: Alternative to serial primary key Richard Huxton 11:54
Atomar SQL Statement Weber, Johann (ISS Kassel) 11:55
Re: Update from join Michael Glaesemann 12:06
Re: Alternative to serial primary key Achilleus Mantzios 12:22
Re: Atomar SQL Statement Michael Glaesemann 13:14
Re: Alternative to serial primary key Sander Steffann 13:26
Re: How to get list of days between two dates? Michael Glaesemann 13:33
SELECT substring with regex T E Schmitz 13:51
create aggregate function 'count_bool( column_name, boolean )' James Moliere 13:53
Re: Alternative to serial primary key Chris Browne 14:33
Re: create aggregate function 'count_bool( column_name, boolean )' Jim Buttafuoco 14:54
Re: SELECT substring with regex Rodrigo De Leon 15:55
Re: SELECT substring with regex Gary Stainburn 15:59
Re: create aggregate function 'count_bool( column_name, boolean )' Richard Broersma Jr 15:59
Re: Alternative to serial primary key Scott Marlowe 16:47
Re: SELECT substring with regex T E Schmitz 17:35
Custom Data Type Mapping JDBC Forums @ Existanze 17:56
Re: Atomar SQL Statement Stephan Szabo 18:07
Re: SELECT substring with regex Rodrigo De Leon 18:37
Re: Atomar SQL Statement Scott Marlowe 18:49
Re: SELECT substring with regex Erik Jones 18:58
Help with performance and explain. Oisin Glynn 19:18
Re: SELECT substring with regex T E Schmitz 19:23
Fwd: Atomar SQL Statement Aaron Bono 19:42
Re: SELECT substring with regex Aaron Bono 19:45
Re: SELECT substring with regex T E Schmitz 20:12
Re: SELECT substring with regex Jim Buttafuoco 20:34
Re: SELECT substring with regex T E Schmitz 20:49
Re: Alternative to serial primary key David Clarke 20:52
Re: Help with performance and explain. Oisin Glynn 21:15
Re: SELECT substring with regex Richard Broersma Jr 21:33
Re: SELECT substring with regex Aaron Bono 22:39

July 8, 2006

Thread Author Time
Re: SELECT substring with regex Rodrigo De Leon 01:24
Re: Atomar SQL Statement Michael Glaesemann 04:17
Celko's Puzzle Number 5 Richard Broersma Jr 06:34
(no subject) onin 08:57
table joining duplicate records onin 09:02
Re: SELECT substring with regex T E Schmitz 09:40
Re: table joining duplicate records Anthony Kinyage 10:35
unsubscribe Patrice OLIVER 11:35
Re: Celko's Puzzle Number 5 Michael Fuhr 11:54
Re: table joining duplicate records Richard Broersma Jr 15:19
Re: Celko's Puzzle Number 5 Richard Broersma Jr 15:20
Re: SELECT substring with regex T E Schmitz 15:40
Re: SELECT substring with regex Rodrigo De Leon 16:48

July 9, 2006

Thread Author Time
Re: table joining duplicate records Richard Broersma Jr 05:56
information_schema for all users Luca Giandoso 07:52
distinct with sum mbobi 08:33
Re: distinct with sum Hélder M. Vieira 12:41
Re: information_schema for all users Michael Fuhr 18:10

July 10, 2006

Thread Author Time
Re: SELECT substring with regex Emils 05:11
Re: Select Maths Phillip Smith 07:21
Re: SELECT substring with regex T E Schmitz 11:02
MS-SQL<->Postgres sync Kevin Bednar 15:27
Re: MS-SQL<->Postgres sync Forums @ Existanze 16:06
Re: MS-SQL<->Postgres sync Andrew Sullivan 16:25
Re: Select Maths Aaron Bono 16:36
Re: MS-SQL<->Postgres sync Aaron Bono 16:48
Re: MS-SQL<->Postgres sync Aaron Bono 17:15
Re: MS-SQL<->Postgres sync Kevin Bednar 17:20
Can function results be used in WHERE? Bryce Nesbitt 17:50
Re: MS-SQL<->Postgres sync Richard Broersma Jr 17:57
Re: SELECT substring with regex Alvaro Herrera 18:29
Re: MS-SQL<->Postgres sync Scott Marlowe 18:30
Re: MS-SQL<->Postgres sync Scott Marlowe 18:31
Re: MS-SQL<->Postgres sync Kevin Bednar 18:59
Re: MS-SQL<->Postgres sync Scott Marlowe 19:02
Re: MS-SQL<->Postgres sync Alvaro Herrera 19:33
Re: Can function results be used in WHERE? Aaron Bono 20:02
Re: MS-SQL<->Postgres sync Dave Page 21:34
Re: Can function results be used in WHERE? Bryce Nesbitt 22:08
Re: Can function results be used in WHERE? Aaron Bono 22:33

July 11, 2006

Thread Author Time
Re: MS-SQL<->Postgres sync Chris Browne 00:12
Re: Can function results be used in WHERE? Bryce Nesbitt 00:24
Re: Select Maths Phillip Smith 00:30
Re: Can function results be used in WHERE? Aaron Bono 03:21
Re: Can function results be used in WHERE? Tom Lane 03:37
Re: Select Maths Aaron Bono 03:41
Re: Select Maths Phillip Smith 03:51
Re: Can function results be used in WHERE? Aaron Bono 04:11
ON INSERT view rule Anthony Chavez 10:53
above the date functionssssssss Penchalaiah P. 11:34
Re: above the date functionssssssss A. Kretschmer 12:02
Re: above the date functionssssssss Stuart 12:02
Re: above the date functionssssssss Michael Fuhr 12:10
Re: ON INSERT view rule Anthony Chavez 12:56
Re: MS-SQL<->Postgres sync Andrew Sullivan 13:17
How to find entries missing in 2nd table? alex-lists-pgsql 14:19
Re: Can function results be used in WHERE? Bryce Nesbitt 15:44
Re: How to find entries missing in 2nd table? Richard Broersma Jr 15:52
Re: How to find entries missing in 2nd table? Scott Marlowe 16:00
Re: How to find entries missing in 2nd table? Frank Bax 16:04
Re: How to find entries missing in 2nd table? Milen A. Radev 16:57
Re: How to find entries missing in 2nd table? Richard Broersma Jr 17:03
Invalid memory alloc request size Daniel Caune 21:29

July 12, 2006

Thread Author Time
Unexpected SQL error for UPDATE aurora 00:47
Re: How to find entries missing in 2nd table? Exner, Peter 08:06
Re: Unexpected SQL error for UPDATE Michael Glaesemann 12:18
Re: Unexpected SQL error for UPDATE Jaime Casanova 13:12
Avoiding RI failure with INSERT ... SELECT FROM Mark Stosberg 13:48
Re: How to find entries missing in 2nd table? Scott Marlowe 18:13
Re: Unexpected SQL error for UPDATE aurora 18:39
Re: Can function results be used in WHERE? Aaron Bono 19:22
Re: SQL (Venn diagram type of logic) Aaron Bono 19:37
Re: Avoiding RI failure with INSERT ... SELECT FROM Aaron Bono 20:06
Logging in Stored Procedure Aaron Bono 23:28

July 13, 2006

Thread Author Time
Re: Logging in Stored Procedure Gregory S. Williamson 00:10
Re: Unexpected SQL error for UPDATE Jaime Casanova 01:48
Re: How to find entries missing in 2nd table? Aaron Bono 15:46
Re: How to find entries missing in 2nd table? Richard Broersma Jr 16:16

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