pgsql-sql since 2005-10-27 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. 27, 2005

Thread Author Time
Yes, pg does triggers first before asserting check constraints! Was Re: why vacuum Bath, David 00:42
Re: Yes, pg does triggers first before asserting check constraints! Was Re: why vacuum Tom Lane 00:55
Re: why vacuum Igor Shevchenko 01:34
handling money type padmanabha konkodi 06:05
How to speed up the database query? Abdul Wahab Dahalan 07:03
Complex Query - Data from 3 tables simultaneously Amit_Wadhwa 07:37
Re: How to speed up the database query? Amit_Wadhwa 07:38
Re: How to speed up the database query? Andreas Kretschmer 07:44
Re: why vacuum Mario Splivalo 08:22
Re: why vacuum Mario Splivalo 08:22
Re: handling money type Richard Huxton 09:14
Re: Complex Query - Data from 3 tables simultaneously Richard Huxton 09:17
Re: why vacuum Andrew Sullivan 10:21
Re: Complex Query - Data from 3 tables simultaneously Amit_Wadhwa 11:23
Re: why vacuum Mario Splivalo 12:34
Re: why vacuum Richard Huxton 13:21
Re: why vacuum Jan Wieck 13:47
Re: why vacuum Jan Wieck 14:12
unsuscribe Ing. Jhon Carrillo-Venezuela 14:29
Re: handling money type codeWarrior 15:34
Re: How to speed up the database query? Christian Paul B. Cosinas 15:45
Re: why vacuum Andrew Sullivan 15:51
Re: How to speed up the database query? Bruno Wolff III 16:31
Re: why vacuum Jan Wieck 17:25
Re: How to speed up the database query? Jim C. Nasby 17:46
Re: why vacuum Jim C. Nasby 17:52
combining records from a single table and presenting them as one record Abhishek 18:00
Re: Merging lines with NULLs (with example data) MaXX 20:07
Referencing lucas 20:24
Re: combining records from a single table and presenting them as one record boinger 21:46
Re: combining records from a single table and presenting Frank Bax 23:37

Oct. 28, 2005

Thread Author Time
Re: converting epoch to timestamp Rajesh Kumar Mallah 04:28
Re: why vacuum Mario Splivalo 11:09
serial in output alessandra de gregorio 11:18
Re: why vacuum Andrew Sullivan 13:34
Fwd: Re: Referencing lucas 13:59
Re: Fwd: Re: Referencing Daryl Richter 15:40
Re: combining records from a single table and presenting them as one record Abhishek 15:47
Re: Fwd: Re: Referencing lucas 16:07
Re: Complex Query - Data from 3 tables simultaneously Muralidharan Ramakrishnan 17:10
Re: combining records from a single table and presenting them as one record Michael Fuhr 17:12
Changing location of ORDER BY has large effect on performance, but not results... Jason Turner 21:30
information_schema problem Kyle Bateman 23:06

Oct. 29, 2005

Thread Author Time
Re: Complex Query - Data from 3 tables simultaneously Amit_Wadhwa 05:45
Two tables or three? James Cloos 13:38
Re: Aggregate versus lineitem report Bruno Wolff III 17:20
Re: Two tables or three? Tom Lane 17:46
Re: Two tables or three? James Cloos 23:59

Oct. 31, 2005

Thread Author Time
Nested Table in PostgreSQL or some alternative Variants Thomas Zuberbuehler 13:22
Re: Fwd: Re: Referencing Daryl Richter 16:32
pgSQL, executing generic query Alessandro Busato 17:43
JOIN condition confusion Thomas Good 18:28
Poor performance in inet << cidr join Axel Rau 18:53
Re: Fwd: Re: Referencing lucas 19:58

Nov. 1, 2005

Thread Author Time
A Not Join L van der Walt 14:27
Re: Fwd: Re: Referencing Daryl Richter 14:45
Re: A Not Join Jim C. Nasby 15:15
Index lookup on > and < criteria David Durham 18:18
Re: Index lookup on > and < criteria A. Kretschmer 19:12
Re: Index lookup on > and < criteria Michael Fuhr 19:21
PGSQL encryption functions Mark R. Dingee 19:38
Re: PGSQL encryption functions Josh Berkus 19:49
Re: Index lookup on > and < criteria David Durham 21:21
Re: PGSQL encryption functions Bruno Wolff III 21:28
Re: PGSQL encryption functions Mark R. Dingee 21:30
Can't Get SETOF Function to Work Lane Van Ingen 21:38
Re: PGSQL encryption functions Mark R. Dingee 22:00
Re: PGSQL encryption functions Tom Lane 22:13
Re: Nested Table in PostgreSQL or some alternative Variants Jim C. Nasby 23:35

Nov. 2, 2005

Thread Author Time
Re: Can't Get SETOF Function to Work Michael Fuhr 00:44
Re: Can't Get SETOF Function to Work Lane Van Ingen 00:55
Re: Index lookup on > and < criteria Michael Fuhr 01:08
Re: A Not Join Jerry Sievers 02:28
Re: PGSQL encryption functions Mario Splivalo 09:26
Re: PGSQL encryption functions Mark R. Dingee 13:29
function, that uses different table(names) Moritz Bayer 13:30
Re: function, that uses different table(names) Moritz Bayer 13:36
Re: function, that uses different table(names) A. Kretschmer 13:38
Re: function, that uses different table(names) A. Kretschmer 13:56
Re: PGSQL encryption functions Neil Saunders 14:04
Re: function, that uses different table(names) Moritz Bayer 14:23
Re: PGSQL encryption functions Tom Lane 14:39
Function with dynamic command (EXECUTE) not working Robert Blixt 14:40
Re: function, that uses different table(names) Tom Lane 14:54
Re: PGSQL encryption functions Bruno Wolff III 18:59
Designing a stock portfolio database Shane 19:40
Re: Index lookup on > and < criteria David Durham 19:42
Re: PGSQL encryption functions Mark R. Dingee 21:01
Re: PGSQL encryption functions Bruno Wolff III 21:14
Re: Poor performance in inet << cidr join (Resolved) Axel Rau 22:07
Re: Poor performance in inet << cidr join (Resolved) Tom Lane 23:22
User input in psql Ashok Agrawal 23:40

Nov. 3, 2005

Thread Author Time
Re: User input in psql Richard Huxton 07:48
Re: Poor performance in inet << cidr join (Resolved) Axel Rau 12:54
Slow query - SELECTing one row from 'big' table. Mario Splivalo 13:59
Re: Welcome to the pgsql-sql list! Achilleus Mantzios 14:42
Re: Slow query - SELECTing one row from 'big' table. Tom Lane 15:17
Encoding on 8.0.4 Don Drake 16:14
date question Judith Altamirano Figueroa 16:17
Re: date question Michael Glaesemann 17:22
Re: date question lucas 17:22
Design question: Scalability and tens of thousands of tables? zackchandler 17:58

Nov. 4, 2005

Thread Author Time
Re: Design question: Scalability and tens of thousands of tables? Michael Glaesemann 06:23
unsubscribe oliverp21 08:00
Re: JOIN condition confusion Richard Huxton 08:12
Re: serial in output Andreas Kretschmer 12:48
Re: serial in output Harald Fuchs 14:03
Re: Changing location of ORDER BY has large effect on performance, but not results... Tom Lane 14:47
Re: Design question: Scalability and tens of thousands of tables? James Robinson 15:11
Re: Design question: Scalability and tens of thousands of tables? Christopher Browne 23:59

Nov. 5, 2005

Thread Author Time
can not connect to pg on linux FC4 Tai Huynh Phuoc 05:12
Extract table columns in tabular form frank church 16:47
Re: Extract table columns in tabular form A. Kretschmer 18:00
Re: Extract table columns in tabular form Christopher Browne 18:14
Insert large text to text column Tai Huynh Phuoc 19:10

Nov. 7, 2005

Thread Author Time
Extract week from date, start with sunday Robert Blixt 13:47
Re: Extract week from date, start with sunday A. Kretschmer 14:27

Nov. 8, 2005

Thread Author Time
Re: Extract week from date, start with sunday Robert Blixt 06:52
Extract date from week lucas 11:25
Re: Returning rows as columns codeWarrior 16:19
Re: Extract date from week Jaime Casanova 19:01
Re: can not connect to pg on linux FC4 Oliver Elphick 21:26

Nov. 9, 2005

Thread Author Time
Re: Design question: Scalability and tens of thousands of george young 02:14
Migrating database from postgresql 7.4.6 to postgresql 8.0.3 Louise Catherine 07:18
Re: Migrating database from postgresql 7.4.6 to postgresql 8.0.3 A. Kretschmer 07:55
Re: Migrating database from postgresql 7.4.6 to postgresql Achilleus Mantzios 08:35
migratation of database from oracle9i to postgreSQL8.0.3 zenith Das 13:55
Como ejecutar una funcion insert en plpgsql.... Fernando Garcia 14:22
RETURNS SETOF table; language 'sql' Mario Splivalo 15:10
Re: Design question: Scalability and tens of thousands of Zack Chandler 16:14
Re: Como ejecutar una funcion insert en plpgsql.... Mauricio Fernandez A. 16:21
Re: RETURNS SETOF table; language 'sql' Tom Lane 18:49
Re: RETURNS SETOF table; language 'sql' Mario Splivalo 21:28
Re: Como ejecutar una funcion insert en plpgsql.... Gregory S. Williamson 21:47
Re: RETURNS SETOF table; language 'sql' Tom Lane 22:05
Re: RETURNS SETOF table; language 'sql' Mario Splivalo 22:17

Nov. 10, 2005

Thread Author Time
Re: Como ejecutar una funcion insert en plpgsql.... Gregory S. Williamson 14:04
Re: [SQL] Como ejecutar una funcion insert en plpgsql.... Jaime Casanova 14:21
time Judith Altamirano Figueroa 15:03
Re: time Judith Altamirano Figueroa 15:16
how to update table to make dup values distinct george young 15:58
Re: RETURNS SETOF table; language 'sql' codeWarrior 16:25
Re: [SQL] Como ejecutar una funcion insert en plpgsql.... Jaime Casanova 16:34
Re: [SQL] Como ejecutar una funcion insert en plpgsql.... Jaime Casanova 16:54
Re: migratation of database from oracle9i to postgreSQL8.0.3 Samer Abukhait 17:21
Re: time Rod Taylor 18:11
Re: time Michael Fuhr 18:21
Re: time Rod Taylor 18:27
Re: time Michael Fuhr 18:38
Re: [SQL] Como ejecutar una funcion insert en plpgsql.... Jaime Casanova 19:02
Re: time Tom Lane 19:13
Re: time Michael Fuhr 19:22
Re: time Tadej Kanizar 19:29
High level discussion for design of using ACL to retrieve Data Joel Fradkin 20:19
Re: time Michael Fuhr 21:30

Nov. 11, 2005

Thread Author Time
Re: how to update table to make dup values distinct Bruno Wolff III 05:05
Re: Como ejecutar una funcion insert en plpgsql.... Gregory S. Williamson 10:24
cli in sql? Frank Bax 13:57
Re: High level discussion for design of using ACL to retrieve Data Joel Fradkin 14:09
Re: how to update table to make dup values distinct Harald Fuchs 14:38
Re: cli in sql? A. Kretschmer 16:09
Export to XML Warren Murray 18:26
Re: cli in sql? Greg Sabino Mullane 20:03
Re: cli in sql? Frank Bax 21:31
pg_dump Judith Altamirano Figueroa 23:04
Re: cli in sql? Tom Lane 23:27

Nov. 13, 2005

Thread Author Time
Problem with "NOT IN (subquery) Steve SAUTETNER 06:27
Re: Problem with "NOT IN (subquery) Stephan Szabo 09:16
Re: Problem with "NOT IN (subquery) - use NOT EXISTS chester c young 17:07

Nov. 14, 2005

Thread Author Time
selective dump pg_dump: only specific non-tables? with schema name? Bath, David 02:08
Re: Problem with "NOT IN (subquery) Christian Paul B. Cosinas 09:47
Connection Oracle database from Postgres function Dinesh Pandey 11:06

Nov. 15, 2005

Thread Author Time
How to Log SELECT Statements Having Errors Lane Van Ingen 01:17
Re: How to Log SELECT Statements Having Errors Richard Huxton 08:46
Re: How to Log SELECT Statements Having Errors Magnus Hagander 08:52
Re: [SQL] pg_dump Oliver Elphick 12:01
Re: How to Log SELECT Statements Having Errors Lane Van Ingen 14:53
[postgres] pgcluster Stephan Fischer 16:21

Nov. 16, 2005

Thread Author Time
Performance of a view John McCawley 17:16

Nov. 17, 2005

Thread Author Time
Arrya variable as argument to IN expression Emil Kaffeshop 08:28
idea for a geographically distributed database: how best to implement? Andy Ballingall 08:44
Re: Arrya variable as argument to IN expression A. Kretschmer 09:26
idea for a geographically distributed database: how best to implement? Andy Ballingall 09:46
Re: Arrya variable as argument to IN expression Achilleus Mantzios 09:51
Re: Arrya variable as argument to IN expression Tom Lane 14:23
Re: idea for a geographically distributed database: how best to implement? codeWarrior 16:00
Re: idea for a geographically distributed database: how best to implement? Andy Ballingall 17:01
Re: idea for a geographically distributed database: how best Andy Ballingall 17:05
Re: idea for a geographically distributed database: how best Achilleus Mantzios 17:36
Geographic DB PaulD 17:37
Geographic DB PaulD 18:40
Geographic Distance Calc website PaulD 21:31
Re: Geographic Distance Calc website Michael Fuhr 22:30
how to do a find and replace Dawn Buie 22:51
[No subject] Brian Doyle 23:00
timestamp SQL question Brian Doyle 23:18
Re: timestamp SQL question codeWarrior 23:35
how to do a find and replace Dawn Buie 23:47
Re: how to do a find and replace Bricklen Anderson 23:55

Nov. 18, 2005

Thread Author Time
Re: how to do a find and replace Dawn Buie 00:08

Browse Archives

Prev | Next