Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query? | Roderick A. Anderson | 12:27 |
| Re[4]: [SQL] Query to eliminate duplicates | Sferacarta Software | 14:48 |
| Re: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query? | Bruce Momjian | 15:26 |
| RE: Re[4]: [SQL] Query to eliminate duplicates | Mario Filipe | 15:42 |
| Re: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query? | Roderick A. Anderson | 19:55 |
| Re: [SQL] DBD | Thomas Good | 21:17 |
| DBD | Bob Kruger | 21:19 |
| Thread | Author | Time |
|---|---|---|
| How can I return multiple rows from a FUNCTION? | Ed Cox | 00:32 |
| How can I return multiple rows from a FUNCTION? (revised) | Ed Cox | 00:35 |
| postmaster tuning commands | pierre | 04:36 |
| Thread | Author | Time |
|---|---|---|
| Howto format a float8 number? | Jerome Knobl | 07:59 |
| Re: [SQL] Howto format a float8 number? | Herouth Maoz | 14:14 |
| Inheritance and origin of rows | joerg.troester | 14:36 |
| ' escape | Fabio Mancinelli | 15:31 |
| Re: [SQL] ' escape | Herouth Maoz | 16:04 |
| Re: [SQL] Odd characters in inserted data... | Sascha Schumann | 18:19 |
| Re: [SQL] ' escape | Jan Wieck | 21:10 |
| Re: [SQL] ' escape | Bruce Momjian | 22:59 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] ' escape | Jan Wieck | 09:27 |
| Re: [SQL] ' escape | Herouth Maoz | 09:45 |
| Oracle SQL 'comment on ...' | Petter Reinholdtsen | 11:54 |
| NULL & NOT NULL | Bill Sneed | 14:28 |
| Re: [GENERAL] NULL & NOT NULL | Herouth Maoz | 14:46 |
| Participate in "Freedom 64-bit CPU" project (PostgreSQL CPU!!) | Dev_Al | 17:38 |
| Thread | Author | Time |
|---|---|---|
| hash table out of memory | Yang Shuqiang | 00:31 |
| [No subject] | lyman1 | 19:46 |
| Fetch syntax problems - ecpg fetches | lyman1 | 19:48 |
| [No subject] | lyman1 | 19:50 |
| Thread | Author | Time |
|---|---|---|
| Lock the server | Michael Yeung | 00:32 |
| Thread | Author | Time |
|---|---|---|
| joins with aggregates | Remigiusz Sokoowski | 14:42 |
| Re: [SQL] joins with aggregates 📎 | George Moga | 15:55 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] char type seems the same as char(1) | Bruce Momjian | 03:41 |
| Re: [SQL] ' escape | Bruce Momjian | 04:33 |
| Re: [SQL] char type seems the same as char(1) | Tom Lane | 17:14 |
| Re: [SQL] char type seems the same as char(1) | Bruce Momjian | 19:31 |
| Re: [SQL] char type seems the same as char(1) | Thomas G. Lockhart | 20:35 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] char type seems the same as char(1) | Thomas G. Lockhart | 00:24 |
| Re: [SQL] char type seems the same as char(1) | Bruce Momjian | 00:45 |
| Re: [SQL] char type seems the same as char(1) | Thomas G. Lockhart | 01:11 |
| Newbie questions | Frank Morton | 02:39 |
| JDBC for postgreSQL?? | Jayvee Vibar | 02:45 |
| Re: [SQL] char type seems the same as char(1) | Bruce Momjian | 03:56 |
| binary search | Vladimir Dobrokhotov | 07:14 |
| Re: [SQL] Newbie questions | Remigiusz Sokolowski | 08:26 |
| Re: [SQL] Newbie questions | Postgres DBA | 11:28 |
| Re[2]: [SQL] Howto format a float8 number? | Sferacarta Software | 14:11 |
| Thread | Author | Time |
|---|---|---|
| Data Dictionary | David Martinez Cuevas | 00:35 |
| Re: [SQL] MINUS and slow 'not in' | David Martinez Cuevas | 02:24 |
| command copy and type char(x) | KOUL Christian | 07:41 |
| CREATE RULE question | Postgres DBA | 08:02 |
| Unix dateformat ? | Zsolt Varga | 08:23 |
| Mea Culpa (was: Unix dateformat ?) | Zsolt Varga | 08:49 |
| Re: [SQL] Unix dateformat ? | George Moga | 09:11 |
| Re: [SQL] CREATE RULE question | Jan Wieck | 09:11 |
| Re: [SQL] binary search | Herouth Maoz | 12:37 |
| Re: [SQL] Newbie questions | Herouth Maoz | 13:13 |
| Re: [SQL] Data Dictionary | Herouth Maoz | 13:30 |
| Re: [SQL] Newbie questions | Remigiusz Sokolowski | 13:41 |
| Re: [SQL] Newbie questions | Herouth Maoz | 14:29 |
| Re: [SQL] MINUS and slow 'not in' | David Hartwig | 14:55 |
| Thread | Author | Time |
|---|---|---|
| About duplicates 📎 | Mario Filipe | 09:53 |
| changing types | Gregory Holston | 13:04 |
| Thread | Author | Time |
|---|---|---|
| printfmt like SQL server? | Douglas Nichols | 00:02 |
| subscribe pgsql-sql | Jos Hernndez Zavala | 05:36 |
| Thread | Author | Time |
|---|---|---|
| Appilcations | Joey Merrell | 18:34 |
| Thread | Author | Time |
|---|---|---|
| PB with Null string | darold | 09:26 |
| Re: [GENERAL] PB with Null string | Postgres DBA | 09:37 |
| Re: [GENERAL] PB with Null string | Herouth Maoz | 09:37 |
| Thread | Author | Time |
|---|---|---|
| Probs with int2 in functions | Gordon Clarke | 06:56 |
| Extremely slow update | Engard Ferenc | 21:55 |
| Thread | Author | Time |
|---|---|---|
| change username | Bill Brandt | 18:15 |
| Re: [SQL] change username | Jan Wieck | 20:19 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] change username | David Hartwig | 00:03 |
| Binary anding | Trever Adams | 00:07 |
| Re: [SQL] Probs with int2 in functions | Jose' Soares | 14:03 |
| booleans | Gregory Holston | 15:39 |
| Re: [SQL] booleans | Jose' Soares | 17:28 |
| Re: [SQL] booleans | Gregory Holston | 17:36 |
| Postgres and Stored Procedures | Larry Bottorff | 17:45 |
| Re: [SQL] booleans | Eric McKeown | 22:45 |
| Regex | John C Cusick | 23:32 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] booleans | Gregory Holston | 14:22 |
| UPDATE table SET col = (SELECT ...) | Eric Marsden | 17:01 |
| Thread | Author | Time |
|---|---|---|
| html table output of table space | pierre | 16:27 |
| Re: [SQL] html table output of table space | Bruce Momjian | 17:22 |
| HELP: Problems with triggers and sql functions | Greg Youngblood | 19:33 |
| Thread | Author | Time |
|---|---|---|
| SELECT DISTINCT | Tim Perdue, The Des Moines City.net | 01:34 |
| Re: [SQL] SELECT DISTINCT | Peter Garner | 02:40 |
| Re: [SQL] SELECT DISTINCT | Tim Perdue, The Des Moines City.net | 03:15 |
| Thread | Author | Time |
|---|---|---|
| c language function | Engard Ferenc | 00:30 |
| Re: [SQL] Probs with int2 in functions | Gordon Clarke | 06:02 |
| Thread | Author | Time |
|---|---|---|
| backend dies when trying a certain kind of a join | Ari Jolma | 07:10 |
| Comments command | Gordon Clarke | 11:30 |
| Triggers and sql functions not working... | Greg Youngblood | 18:33 |
| RE: [SQL] Probs with int2 in functions | Jackson, DeJuan | 23:40 |
| Thread | Author | Time |
|---|---|---|
| Converting int4 to varchar | Larry Bottorff | 14:45 |
| Re: [SQL] Triggers and sql functions not working... | Jan Wieck | 15:41 |
| I cant delete.... | Gomez Eduardo Antonio | 15:50 |
| drop table in pgsql | Pawel Pierscionek | 21:20 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Kind of Funny | Bruce Momjian | 02:22 |
| Kind of Funny | Frank Morton | 02:26 |
| Bit Operators | Jin Hui | 06:20 |
| placeholders | martin | 07:01 |
| plpgsql problems | Pawel Pierscionek | 09:50 |
| Re: [SQL] drop table in pgsql | Jan Wieck | 10:19 |
| Importing Fixed-Width File? | Tim Perdue | 12:23 |
| Re: [SQL] drop table in pgsql | Pawel Pierscionek | 14:43 |
| rules and referential integrity | Brook Milligan | 15:12 |
| Re: [SQL] placeholders | Gene Selkov Jr. | 16:05 |
| RE: [SQL] Kind of Funny | Jackson, DeJuan | 19:32 |
| LIKE query over multiple fields | Nathan Hand | 20:49 |
| Importing Fixed-Width File? | Tim Perdue, The Des Moines City.net | 23:16 |
| Re: [SQL] placeholders | martin | 23:52 |
| Thread | Author | Time |
|---|---|---|
| int4 to varchar conversion | Larry Bottorff | 15:31 |
| Re: [SQL] int4 to varchar conversion | George Moga | 16:07 |
| Re: [SQL] int4 to varchar conversion | Larry Bottorff | 17:06 |
| Postgres functions and Stored Procedures? | Kim Markle | 17:44 |
| Case insensitive equality operator 📎 | Christophe Labouisse | 22:25 |
| Thread | Author | Time |
|---|---|---|
| RE: [SQL] Case insensitive equality operator | Jackson, DeJuan | 19:21 |
| force indexed search? | Nick Massaro | 23:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Insert composite type in table | kb chair | 10:44 |
| SELECT... BETWEEN 'P' and 'Z' | Tim Perdue, The Des Moines City.net | 18:03 |
| unsubscribe | Zmarzlowski | 20:11 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] SELECT... BETWEEN 'P' and 'Z' | Bruce Momjian | 01:37 |
| Re: [SQL] SELECT... BETWEEN 'P' and 'Z' | Tim Perdue, The Des Moines City.net | 04:02 |
| Re: [SQL] SELECT... BETWEEN 'P' and 'Z' | Bruce Momjian | 06:29 |
| Re: [SQL] SELECT... BETWEEN 'P' and 'Z' | Tim Perdue, The Des Moines City.net | 14:18 |
| Re: [SQL] SELECT... BETWEEN 'P' and 'Z' | Bruce Momjian | 16:43 |
| Thread | Author | Time |
|---|---|---|
| Embedded SQL | Ansley, Michael | 07:32 |
| storing strings with embedded '\' | Joel Fischer | 21:05 |
| Re: [SQL] storing strings with embedded '\' | Frank Morton | 22:13 |
| Temporary tables | Pawel Pierscionek | 22:39 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] storing strings with embedded '\' | Dirk Lutzebaeck | 09:42 |
| [SQL] Tricky -to me!- SQL query. | Stuart Rison | 11:17 |
| Re: [SQL] Tricky -to me!- SQL query. | Remigiusz Sokolowski | 11:44 |
| Re: [SQL] Tricky -to me!- SQL query. | Stuart Rison | 13:41 |
| Re: [SQL] Tricky -to me!- SQL query. | Remigiusz Sokolowski | 13:48 |
| A path through a tree | Neil Burrows | 14:34 |
| Re: storing strings with embedded '\' | Tom Lane | 15:17 |
| Re: [SQL] A path through a tree | David Martinez Cuevas | 16:50 |
| Re: [SQL] A path through a tree | Bruce Stephens | 19:09 |
| RE: [SQL] SELECT... BETWEEN 'P' and 'Z' | Greg Youngblood | 19:28 |
| Text type | Gregory Holston | 22:56 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Text type | Remigiusz Sokolowski | 07:56 |
| Re: [SQL] Tricky -to me!- SQL query. | Jan Wieck | 09:59 |
| Re: [SQL] Text type | Guido Goldstein | 13:39 |
| Problem with simple select, RestrictionClauseSelectivity ERROR | Patricia Rodriguez-Tome | 17:34 |
| Sequences and Views | JP Rosevear | 18:28 |
| Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR | Bruce Momjian | 18:51 |
| Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR | Ari Jolma | 19:24 |
| Solaris Startup | Frank Morton | 19:48 |
| RE: [SQL] A path through a tree | Jackson, DeJuan | 23:20 |
| RE: [SQL] Text type | Jackson, DeJuan | 23:38 |
| Thread | Author | Time |
|---|---|---|
| RE: [SQL] Sequences and Views | Jackson, DeJuan | 00:23 |
| Geometry filed type | Chatchawan Boonraksa | 00:59 |
| very slow response time on large, multi-table view | Charles Hornberger | 01:23 |
| More view problems | JP Rosevear | 05:03 |
| Re: [SQL] More view problems | Jan Wieck | 08:16 |
| Indexes on OIDs ? | Dirk Lutzebaeck | 09:24 |
| Indexes on OIDs ? | Dirk Lutzebaeck | 09:24 |
| Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR | Dirk Lutzebaeck | 09:25 |
| rule plan string too big. | Dirk Lutzebaeck | 11:03 |
| Re: [SQL] rule plan string too big. | Jan Wieck | 11:21 |
| byte | Remigiusz Sokolowski | 14:12 |
| Re: [SQL] Indexes on OIDs ? | Bruce Momjian | 14:55 |
| [No subject] | Stefan Kapfhammer | 15:04 |
| Re: [SQL] Solaris Startup | Roberto Joao Lopes Garcia | 15:11 |
| Re: [SQL] Text type | Frank Barknecht | 15:28 |
| RE: [SQL] A path through a tree | Jackson, DeJuan | 16:18 |
| many to many relationship Query ? | Morris, Sam@EDD | 19:04 |
| Thread | Author | Time |
|---|---|---|
| Triggers, plpgsql, etc. 📎 | Christophe Labouisse | 12:10 |
| Re: [SQL] Triggers, plpgsql, etc. | Jan Wieck | 17:36 |
| Re: [SQL] Text type | Gene Selkov Jr. | 19:39 |
| Thread | Author | Time |
|---|---|---|
| Viewing access privileges | Stephen Davies | 09:00 |
| Re: [SQL] Viewing access privileges | Tim J Trowbridge | 19:24 |
| Thread | Author | Time |
|---|---|---|
| subscribe [email protected] | WolfySu | 03:01 |
| Thread | Author | Time |
|---|---|---|
| Inserting/updating points | Holger Mitterwald | 09:02 |
| need help with error: cannot find attribute 1 of relation... | Michael Olivier | 21:23 |
| Thread | Author | Time |
|---|---|---|
| binary operators / C func getting "invalid ELF header" | Michael Olivier | 00:51 |
| Re: [SQL] binary operators / C func getting "invalid ELF header" | Gene Selkov Jr. | 01:47 |
| Re: [SQL] binary operators / C func getting "invalid ELF header" | Gregory W Burnham | 03:18 |
| Time format | Shane Wilson | 15:32 |
| Re: [SQL] binary operators / C func getting "invalid ELF header" | Michael Olivier | 19:15 |
| RE: [SQL] binary operators / C func getting "invalid ELF header" | Jackson, DeJuan | 20:46 |
| set type and in clause | frank | 22:25 |
| Re: [SQL] set type and in clause | Brian Baquiran | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Beginner question - select with multiple tables | Dave Inskeep | 04:51 |
| Re: [SQL] Beginner question - select with multiple tables | Herouth Maoz | 09:44 |
| Re: [SQL] set type and in clause | Herouth Maoz | 10:11 |
| Text type function | Yuri Yurchenko | 10:19 |
| RE: [SQL] Beginner question - select with multiple tables | Jackson, DeJuan | 15:25 |
| Selecting Table cell names | James Andrews | 16:14 |
| Faster LIKE | Frank Morton | 16:15 |
| RE: [SQL] Faster LIKE | Jackson, DeJuan | 16:17 |
| RE: [SQL] A path through a tree | Jackson, DeJuan | 16:20 |
| RE: [SQL] binary operators / C func getting "invalid ELF header" | Michael Olivier | 19:05 |
| XML DOM and Postgres | Ray Racine | 19:13 |
| Thread | Author | Time |
|---|---|---|
| Getting Table Cell names from select statement. | James Andrews | 02:06 |
| Max Length of SQL | Tim Perdue, The Des Moines City.net | 06:20 |
| insert into help | Walt Bigelow | 12:46 |