pgsql-sql since 2004-08-14 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Aug. 14, 2004

Thread Author Time
Re: tablefunc's in 8.0 Beta Win32 - where? Thomas Wegner 22:20

Aug. 15, 2004

Thread Author Time
Re: LIKE '%%' does not return NULL Stephan Szabo 18:56
Re: LIKE '%%' does not return NULL Frank Finner 19:17
Re: Getting points from polygon Tom Lane 19:43
CROSS-TAB query help? I have read it cant be done in one SQL, pro ve them wrong! Theo Galanakis 23:46

Aug. 16, 2004

Thread Author Time
Re: COMMENT ON CONSTRAINT Andreas Seltenreich 01:03
Inheriting text[] field Kaloyan Iliev Iliev 07:06
Re: duplicate table in two databases Richard Huxton 08:01
Re: CROSS-TAB query help? I have read it cant be done in one Richard Huxton 08:06
Re: Returning A Varchar From A Function George Weaver 12:40
SQL_ASCII and UNICODE server_encoding Achilleus Mantzios 13:56
Re: Inheriting text[] field Tom Lane 14:28
Re: SQL_ASCII and UNICODE server_encoding Achilleus Mantzios 14:42
Re: SQL_ASCII and UNICODE server_encoding Tom Lane 15:04
any chance SQL ASSERTIONS will be implemented? Markus Bertheau 20:15
Re: any chance SQL ASSERTIONS will be implemented? Peter Eisentraut 20:41
Verifying data type Elieser Leão 21:16
Re: Verifying data type Tom Lane 23:30

Aug. 17, 2004

Thread Author Time
Re: CROSS-TAB query help? I have read it cant be done in on Theo Galanakis 02:47
multi column foreign key for implicitly unique columns Markus Bertheau 09:25
Re: multi column foreign key for implicitly unique columns Oliver Elphick 09:39
Re: CROSS-TAB query help? I have read it cant be done in on Richard Huxton 09:48
Re: multi column foreign key for implicitly unique columns Markus Bertheau 09:49
Re: multi column foreign key for implicitly unique columns Richard Huxton 09:52
only last records in subgroups Dino Vliet 10:44
SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau 11:07
Re: only last records in subgroups Achilleus Mantzios 11:35
Re: Inheriting text[] field Kaloyan Iliev Iliev 13:16
Re: Verifying data type Elieser Leão 13:48
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III 14:12
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau 14:21
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance 14:26
Re: multi column foreign key for implicitly unique columns Stephan Szabo 14:26
Re: multi column foreign key for implicitly unique columns Tom Lane 14:46
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau 14:51
Re: multi column foreign key for implicitly unique columns Markus Bertheau 14:57
Re: multi column foreign key for implicitly unique columns Stephan Szabo 15:06
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Stephan Szabo 15:09
Re: multi column foreign key for implicitly unique columns Markus Bertheau 15:12
Re: multi column foreign key for implicitly unique columns Stephan Szabo 15:24
Re: multi column foreign key for implicitly unique columns Tom Lane 15:38
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance 15:54
Possible rounding error of large float values? Adam Lancaster 17:21
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III 17:31

Aug. 18, 2004

Thread Author Time
Re: multi column foreign key for implicitly unique columns Josh Berkus 02:45
SQL Challenge: Arbitrary Cross-tab Josh Berkus 02:55
Re: SQL Challenge: Arbitrary Cross-tab elein 03:18
Re: SQL Challenge: Arbitrary Cross-tab Stephan Szabo 03:35
Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane 03:36
Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus 03:41
Re: SQL Challenge: Arbitrary Cross-tab Joe Conway 05:15
Re: multi column foreign key for implicitly unique columns Markus Bertheau 06:00
[No subject] Theo Galanakis 06:11
Re: SQL Challenge: Arbitrary Cross-tab Gaetano Mendola 11:01
Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane 11:47
Re: multi column foreign key for implicitly unique columns Jan Wieck 13:33
Re: multi column foreign key for implicitly unique columns Markus Bertheau 13:49
Re: multi column foreign key for implicitly unique columns Jan Wieck 14:06
Re: multi column foreign key for implicitly unique columns Markus Bertheau 14:28
Re: multi column foreign key for implicitly unique columns Stephan Szabo 14:38
Re: SQL Challenge: Arbitrary Cross-tab Gaetano Mendola 14:48
Re: SQL Challenge: Arbitrary Cross-tab Tom Lane 15:13
Re: multi column foreign key for implicitly unique columns Tom Lane 15:16
/contrib and win32 Bruce Momjian 15:30
Re: multi column foreign key for implicitly unique columns Rod Taylor 15:45
Re: multi column foreign key for implicitly unique columns Richard Huxton 16:02
Re: SQL Challenge: Arbitrary Cross-tab Chris Travers 16:11
Re: multi column foreign key for implicitly unique columns Tom Lane 16:18
Re: multi column foreign key for implicitly unique columns Jan Wieck 16:27
Re: multi column foreign key for implicitly unique columns Rod Taylor 16:46
Re: multi column foreign key for implicitly unique columns Tom Lane 16:46
Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus 16:56
Re: multi column foreign key for implicitly unique columns Josh Berkus 17:05
Re: multi column foreign key for implicitly unique columns Stephan Szabo 17:45
Re: multi column foreign key for implicitly unique columns Richard Huxton 17:49
Re: SQL Challenge: Arbitrary Cross-tab Joe Conway 17:54
Re: multi column foreign key for implicitly unique columns Jan Wieck 18:01
Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus 18:52
Re: multi column foreign key for implicitly unique columns Josh Berkus 18:55
Re: multi column foreign key for implicitly unique columns Bruno Wolff III 19:24
Re: multi column foreign key for implicitly unique columns Josh Berkus 19:36
Re: Theo Galanakis 22:29
Re: multi column foreign key for implicitly unique columns Jan Wieck 22:33

Aug. 19, 2004

Thread Author Time
Function Issue! Theo Galanakis 01:10
Re: Function Issue! Tom Lane 01:36
Re: multi column foreign key for implicitly unique columns Josh Berkus 16:21
Re: multi column foreign key for implicitly unique columns Oliver Elphick 16:52
Re: multi column foreign key for implicitly unique columns Jan Wieck 21:41
help with scheme changes to live system. Tony Yang 22:00

Aug. 20, 2004

Thread Author Time
Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane 02:16
Re: SQL Challenge: Arbitrary Cross-tab Tom Lane 03:25
Re: multi column foreign key for implicitly unique columns Richard Huxton 07:53
Re: multi column foreign key for implicitly unique columns Stephan Szabo 15:04
Problems importing data Devin Whalen 15:17
view triggers/procedures SVGK, Raju (Raju) 15:55
olympics ranking query David Garamond 16:40
Re: olympics ranking query Tom Lane 16:46
Re: olympics ranking query Bruno Wolff III 17:01
Re: olympics ranking query David Garamond 17:11
Re: olympics ranking query Tom Lane 17:21
Re: olympics ranking query David Garamond 17:27
Re: olympics ranking query Mischa Sandberg 18:29
problem with RULE Sreten Milosavljevic 21:17

Aug. 22, 2004

Thread Author Time
disable constrained (contd.) Roman Kunert 00:41
ERROR: Invalid regular expression: parentheses ( ) not balanced Kathrine S 19:51
Re: reply to setting Greg Stark 19:58

Aug. 23, 2004

Thread Author Time
pg_dump/pg_restore question Worik 02:59
Re: sleep function Greg Stark 03:52
Re: only last records in subgroups Greg Stark 04:09
Re: pg_dump/pg_restore question Iain 04:57
Re: pg_dump/pg_restore question Richard Huxton 07:56
array_in: '{}}'::text[] Markus Bertheau 11:45
Re: array_in: '{}}'::text[] Markus Bertheau 11:50
Re: disable constrained (contd.) Markus Bertheau 11:51
Re: sleep function John DeSoi 13:36
TSearch2 other languages Cavit Keskin 15:12
CREATE TYPE VARCHAR2 Sascha Ziemann 17:08
Re: array_in: '{}}'::text[] Joe Conway 18:32
Re: reply to setting Joe Conway 21:06

Aug. 24, 2004

Thread Author Time
Re: [SQL] TSearch2 other languages Josh Berkus 01:15
Re: surrogate key or not? sad 04:31
Disable trigger with Postgresql 7.4.x? Philippe Lang 07:41
stored procedures and type of returned result. Patrice OLIVER 08:39
Re: stored procedures and type of returned result. Richard Huxton 09:26
Re: stored procedures and type of returned result. Philippe Lang 09:56
Re: stored procedures and type of returned result. Richard Huxton 10:41
Re: Disable trigger with Postgresql 7.4.x? Bruce Momjian 11:20
refer to computed columns Bruno Mueller 15:10
Re: Possible rounding error of large float values? Josh Berkus 19:52
Re: Possible rounding error of large float values? Oliver Elphick 20:21

Aug. 25, 2004

Thread Author Time
Re: Possible rounding error of large float values? Jan Wieck 00:39
Re: Possible rounding error of large float values? Iain 01:32
Re: Possible rounding error of large float values? Stephan Szabo 01:41
Re: Possible rounding error of large float values? Iain 02:48
PQexec and SPI_exec Pedro B. 14:21
Optimizer Selecting Incorrect Index David Price 14:49
Re: PQexec and SPI_exec Jan Wieck 14:53
Complicated "group by" question Andrew Perrin 17:04
Re: Complicated "group by" question Josh Berkus 17:47
Re: Complicated "group by" question Jean-Luc Lachance 17:54
Re: Complicated "group by" question Andrew Perrin 18:20

Aug. 26, 2004

Thread Author Time
Re: CREATE TYPE VARCHAR2 Tom Lane 02:07
Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Tom Lane 02:21
Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Adrian Klaver 02:44
Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Tom Lane 02:54
Aggregate query for multiple records Scott Gerhardt 06:23
Re: from PG_DUMP to CVS Kenneth Gonsalves 09:48
from PG_DUMP to CVS Riccardo G. Facchini 10:04
Re: from PG_DUMP to CVS Philip Warner 10:32
Re: from PG_DUMP to CVS Riccardo G. Facchini 10:43
Re: from PG_DUMP to CVS Philip Warner 11:18
Re: from PG_DUMP to CVS Riccardo G. Facchini 11:48
Re: from PG_DUMP to CVS Riccardo G. Facchini 12:05
Auto-update script from dumps? Joerg Hessdoerfer 13:06
Problem with stored procedure 📎 Patrice OLIVER 13:07
Re: Problem with stored procedure Richard Huxton 13:31
Re: Problem with stored procedure Antonis Antoniou 14:59
expression_tree_walker: Unexpected node type 711 Ian Percival 15:58
Re: from PG_DUMP to CVS Greg Stark 17:06
Pb with insert statement 📎 Patrice OLIVER 21:12

Aug. 27, 2004

Thread Author Time
Re: from PG_DUMP to CVS Josh Berkus 04:38
Re: Aggregate query for multiple records Josh Berkus 04:55
Abwesenheitsnotiz: approved document Gerdes, Heino 05:27
backup of a specific schema Kenneth Gonsalves 05:51
Re: backup of a specific schema Riccardo G. Facchini 07:53
Re: backup of a specific schema Kenneth Gonsalves 07:58
Re: Aggregate query for multiple records Troy 09:32
Re: from PG_DUMP to CVS Philip Warner 11:15
Re: from PG_DUMP to CVS Riccardo G. Facchini 13:06
GRANT ON all tables Nosyman 15:30
Re: Aggregate query for multiple records Josh Berkus 15:43
Re: from PG_DUMP to CVS Josh Berkus 16:02
Re: Aggregate query for multiple records Josh Berkus 18:59
Re: GRANT ON all tables Bruno Wolff III 19:20
Re: help with trigger Dino Vliet 19:35
Copy command freezes but INSERT works fine with trigger on insert. Artimenko Igor 20:16
Re: Aggregate query for multiple records Josh Berkus 20:19
Re: Copy command freezes but INSERT works fine with trigger oninsert. Gregory S. Williamson 20:29
Re: [SQL] array_in: '{}}'::text[] 📎 Joe Conway 20:37
Re: Copy command freezes but INSERT works fine with trigger on insert. Artimenko Igor 20:53
Re: [PERFORM] Why those queries do not utilize indexes? Artimenko Igor 21:33

Aug. 28, 2004

Thread Author Time
Re: backup of a specific schema Gaetano Mendola 02:16
Re: [SQL] array_in: '{}}'::text[] Tom Lane 03:05
Re: Aggregate query for multiple records Greg Stark 08:35
Re: backup of a specific schema Gaetano Mendola 12:48
Re: from PG_DUMP to CVS Philip Warner 16:10
Re: Aggregate query for multiple records Tom Lane 16:19
Re: Aggregate query for multiple records Scott Gerhardt 18:08
Re: [SQL] array_in: '{}}'::text[] 📎 Joe Conway 19:33
Re: [SQL] array_in: '{}}'::text[] Markus Bertheau 20:09
Re: [SQL] array_in: '{}}'::text[] Joe Conway 22:41
Re: backup of a specific schema Kenneth Gonsalves 23:59

Aug. 29, 2004

Thread Author Time
Re: backup of a specific schema Gaetano Mendola 11:20
Re: expression_tree_walker: Unexpected node type 711 Tom Lane 16:26

Aug. 30, 2004

Thread Author Time
function fails where individual statements succeed Rosser Schwarz 17:17
Re: function fails where individual statements succeed Rosser Schwarz 18:34
Re: function fails where individual statements succeed Tom Lane 20:32
Re: function fails where individual statements succeed Rosser Schwarz 20:40
Re: function fails where individual statements succeed Tom Lane 21:03
Re: function fails where individual statements succeed Rosser Schwarz 22:12

Browse Archives

Prev | Next