pgsql-sql since 2005-10-29 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. 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
Re: how to do a find and replace Bricklen Anderson 00:12
Re: how to do a find and replace Hélder M. Vieira 01:10
query Aftab Alam 05:25
Re: how to do a find and replace A. Kretschmer 06:15
Re: idea for a geographically distributed database: how best to implement? Andy Ballingall 09:09
Re: idea for a geographically distributed database: how best to implement? Andrew Sullivan 15:06
Re: how to do a find and replace Andrew Sullivan 15:19
Re: Export to XML Dean Gibson (DB Administrator) 21:16
DISTINCT ON Jeremy Palmer 22:49
Re: DISTINCT ON Michael Glaesemann 23:27

Nov. 19, 2005

Thread Author Time
Re: DISTINCT ON Jeremy Palmer 02:50
Re: DISTINCT ON Michael Glaesemann 03:06
Re: DISTINCT ON Jeremy Palmer 04:06
Re: Export to XML Nikolay Samokhvalov 12:27
Re: DISTINCT ON Bruno Wolff III 14:31

Nov. 20, 2005

Thread Author Time
Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall 00:27
Create Public Schema 📎 rsosnowski 03:03
Re: Is it possible to redirect an update/insert/delete to a different table? JuanCri 06:43
Re: query JuanCri 07:01
Re: Create Public Schema Andreas Kretschmer 08:49
Trigger / rule question Joost Kraaijeveld 09:18
Re: Create Public Schema Mario Splivalo 10:35
Re: Is it possible to redirect an update/insert/delete to a different table? Peter Eisentraut 11:07
Re: Trigger / rule question Peter Eisentraut 11:08
Re: Is it possible to redirect an update/insert/delete to a different table? Jaime Casanova 14:23
Re: Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall 15:28
Re: Trigger / rule question Joost Kraaijeveld 15:36
Re: Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall 15:40
Re: Is it possible to redirect an update/insert/delete to a different table? Andreas Kretschmer 16:17
Re: Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall 16:37
Re: Is it possible to redirect an update/insert/delete to a different table? Andreas Kretschmer 16:42
Re: Is it possible to redirect an update/insert/delete to a different table? Andreas Kretschmer 17:01
Re: Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall 17:15
Please help to wite the constraint. Grigory O. Ptashko 19:32
Re: Is it possible to redirect an update/insert/delete to a different table? Adrian Klaver 23:35

Nov. 21, 2005

Thread Author Time
max() unexpected type conversion Hélder M. Vieira 12:47
Re: max() unexpected type conversion Tom Lane 15:03
Re: A Not Join stig erikson 20:16
tid_le comparison for tuple id (ctid) values? george young 21:00
Re: tid_le comparison for tuple id (ctid) values? Tom Lane 21:19
Storing HTML in table Rob 21:47

Nov. 22, 2005

Thread Author Time
Re: idea for a geographically distributed database: how best to implement? Bath, David 00:02
unplanned sub-select error? Kyle Bateman 00:37

Browse Archives

Prev | Next