Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: nextval on insert by arbitrary sequence | Dado Feigenblatt | 00:04 |
| Re: nextval on insert by arbitrary sequence | David Stanaway | 04:30 |
| Re: When PostgreSQL compliant JDBC 2.0? | Ed Yu | 05:50 |
| Re: CAST(ipaddress as text) -- HOW? | Bhuvan A | 05:58 |
| Re: Records exactly the same. | Fons Rave | 12:15 |
| Re: Re: PLpgSQL 📎 | Josh Berkus | 16:30 |
| Thread | Author | Time |
|---|---|---|
| unique index on more than one field using functions | Domingo Alvarez Duarte | 10:14 |
| Re: Get the tables names? | D'Arcy J.M. Cain | 12:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Query optimizing - paradox behave 📎 | David M. Richter | 11:11 |
| Table scan instead of index scan | Mário Sérgio G Antunes | 13:07 |
| Re: how can we get total records in pg server? | Bhuvan A | 13:33 |
| Re: Table scan instead of index scan | Stephan Szabo | 13:34 |
| How to get the server version?? | Roberto João Lopes Garcia | 13:50 |
| Re: position(text,text) function | Karl Orbell | 13:53 |
| Re: How to get the server version?? | Richard Huxton | 14:23 |
| Re: How to get the server version?? | omid omoomi | 14:24 |
| Re: How to get the server version?? | Ross J. Reedstrom | 14:37 |
| Re: Query optimizing - paradox behave 📎 | David M. Richter | 15:24 |
| Re: how can we get total records in pg server? 📎 | Josh Berkus | 15:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: When PostgreSQL compliant JDBC 2.0? | Tom Lane | 00:30 |
| Re: nextval on insert by arbitrary sequence | Henry House | 05:57 |
| Re: Determining if two subnets intersect | Tom Lane | 06:49 |
| Inserts in triggers | Morgan Curley | 07:11 |
| Inserts in triggers | Morgan Curley | 07:12 |
| Re: Determining if two subnets intersect | Florian Weimer | 07:17 |
| Re: Inserts in triggers | Richard Huxton | 08:56 |
| Re: Inserts in triggers Follow Up | Morgan Curley | 13:09 |
| Re: how can we get total records in pg server? | Henshall, Stuart - WCP | 13:13 |
| Meta integrity | Renato De Giovanni | 15:08 |
| Re: Re: Inserts in triggers Follow Up 📎 | Josh Berkus | 15:14 |
| Re: Meta integrity 📎 | Josh Berkus | 15:22 |
| Re: Inserts in triggers | Tom Lane | 15:31 |
| Re: Re: Inserts in triggers Follow Up | Tom Lane | 15:43 |
| Re: Re: Inserts in triggers Follow Up 📎 | Josh Berkus | 15:53 |
| Re: Meta integrity | Stephan Szabo | 16:26 |
| Re: Meta integrity | Grigoriy G. Vovk | 17:49 |
| about cursor | frederic romagna | 17:55 |
| Thread | Author | Time |
|---|---|---|
| Need help in how to.... | Edipo Elder Fernandes de Melo | 14:23 |
| Re: [SQL] When PostgreSQL compliant JDBC 2.0? (Batch updates) | Barry Lind | 16:34 |
| performance issue with distance function | Ryan Littrell | 20:04 |
| Re: [SQL] Re: When PostgreSQL compliant JDBC 2.0? | Bruce Momjian | 20:59 |
| Restriction by grouping problem. | Jeff Barrett | 21:09 |
| Re: performance issue with distance function | Jeff Hoffmann | 21:20 |
| Re: Restriction by grouping problem. | Josh Berkus | 21:50 |
| Re: Restriction by grouping problem. | Jeff Barrett | 22:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Restriction by grouping problem. | Philip Warner | 01:47 |
| Re: Meta integrity | Tom Lane | 05:20 |
| Re: Re: Restriction by grouping problem. | Philip Warner | 07:50 |
| nullif BUG??? | guard | 09:48 |
| Re: nullif BUG??? 📎 | Josh Berkus | 15:19 |
| Re: D308-E9AF-4C11 : CONFIRM from pgsql-sql (subscribe) | Gonzo Rock | 18:01 |
| Re: D308-E9AF-4C11 : CONFIRM from pgsql-sql (subscribe) | Gonzo Rock | 18:02 |
| Database Design Question | Gonzo Rock | 18:03 |
| Re: Re: D308-E9AF-4C11 : CONFIRM from pgsql-sql (subscribe) | Mike Mascari | 18:31 |
| RE: Database Design Question | Jimmie Fulton | 18:33 |
| RE: [SQL] Database Design Question | Gonzo Rock | 20:21 |
| Re: RE: [SQL] Database Design Question 📎 | Ryan Mahoney | 20:24 |
| Re: RE: [SQL] Database Design Question | Mike Mascari | 20:39 |
| Re: Database Design Question | James Orr | 20:51 |
| RE: Database Design Question | Jimmie Fulton | 22:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Restriction by grouping problem. | Josh Berkus | 00:19 |
| Re: Re: Restriction by grouping problem. | Philip Warner | 01:31 |
| Get name of columns in a table | María Elena Hernández | 01:36 |
| Why does this plpgslq always return 1? | John Oakes | 03:00 |
| RE: Database Design Question | Joel Burton | 03:22 |
| Re: Why does this plpgslq always return 1? | Stephan Szabo | 03:48 |
| Re: Get name of columns in a table | Joel Burton | 14:31 |
| Who do I make _ not a wildcard? | Roy Souther | 18:12 |
| Re: Who do I make _ not a wildcard? | Stephan Szabo | 19:18 |
| Thread | Author | Time |
|---|---|---|
| Re: nullif BUG??? | Tom Lane | 03:15 |
| Re: performance issue with distance function | Mark kirkwood | 04:30 |
| Re: Re: Restriction by grouping problem. | Tom Lane | 20:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Who do I make _ not a wildcard? | Bruce Momjian | 03:38 |
| Date Time Functions - ANSI SQL ? | Gonzo Rock | 04:19 |
| Re: Date Time Functions - ANSI SQL ? | Tom Lane | 05:39 |
| Re: Re: Inserts in triggers Follow Up | Jan Wieck | 14:26 |
| Big table - using wrong index - why? | Chris Ruprecht | 16:20 |
| Re: Big table - using wrong index - why? | Joe Conway | 16:43 |
| Re: Why does this plpgslq always return 1? | Jan Wieck | 16:56 |
| Re: Date Time Functions - ANSI SQL ? | Gonzo Rock | 17:39 |
| plpgsql function return multiple values? | John Oakes | 17:46 |
| Re: plpgsql function return multiple values? | Jan Wieck | 18:11 |
| Re: Big table - using wrong index - why? | Chris Ruprecht | 18:54 |
| Re: Big table - using wrong index - why? | Tom Lane | 19:20 |
| Thread | Author | Time |
|---|---|---|
| Why can't I ......... | Mounir Benzid | 07:54 |
| union in subselect? | Gary Stainburn | 14:42 |
| Re: Get name of columns in a table | Richard Huxton | 14:54 |
| Re: union in subselect? | Tom Lane | 15:16 |
| Fuzzy matching? 📎 | Josh Berkus | 16:05 |
| Re: Fuzzy matching? | Joe Conway | 17:07 |
| RE: Fuzzy matching? | Robby Slaughter | 17:07 |
| Re: Fuzzy matching? | Josh Berkus | 17:34 |
| Re: Fuzzy matching? | Joe Conway | 17:41 |
| Re: Fuzzy matching? | Tom Lane | 17:44 |
| Re: Fuzzy matching? | Bruce Momjian | 17:53 |
| Re: Fuzzy matching? | Joe Conway | 18:06 |
| Re: Fuzzy matching? | Bruce Momjian | 18:11 |
| Re: Fuzzy matching? | Josh Berkus | 18:15 |
| Re: Fuzzy matching? | Tom Lane | 18:48 |
| Re: Fuzzy matching? | Tom Lane | 20:09 |
| RE: Fuzzy matching? | Jeff Eckermann | 20:23 |
| Re: Fuzzy matching? | Josh Berkus | 20:53 |
| Re: Fuzzy matching? | Christopher Sawtell | 21:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Fuzzy matching? 📎 | Timothy H. Keitt | 02:27 |
| Re: Fuzzy matching? | Timothy H. Keitt | 02:40 |
| Converting epoch to timestamp? | Roberto Mello | 06:57 |
| Re: Converting epoch to timestamp? | Richard Huxton | 08:28 |
| Re: Converting epoch to timestamp? | Roberto Mello | 13:29 |
| Re: Converting epoch to timestamp? | Tom Lane | 14:02 |
| Re: When PostgreSQL compliant JDBC 2.0? | Gunnar Rønning | 14:14 |
| Exclusion List | Michael Richards | 15:28 |
| Re: Exclusion List | Tom Lane | 16:23 |
| Re: Exclusion List | Michael Richards | 16:29 |
| Re: Outer Join Syntax | Joe Conway | 17:28 |
| Re: Outer Join Syntax | Tom Lane | 18:06 |
| Thread | Author | Time |
|---|---|---|
| Re: where'd the spaces come from | Bruce Momjian | 15:50 |
| Re: where'd the spaces come from | Gary Stainburn | 15:56 |
| Re: Fuzzy matching? | Oleg Bartunov | 16:16 |
| Foreign key | Lorenzo De Vito | 16:23 |
| Re: where'd the spaces come from | Bruce Momjian | 16:31 |
| RE: Foreign key | Robby Slaughter | 18:19 |
| Re: Foreign key | Jason Earl | 19:43 |
| More Database Design Stuff | Jimmie Fulton | 20:23 |
| Re: Foreign key | Jan Wieck | 20:56 |
| Re: More Database Design Stuff | Chris Ruprecht | 20:59 |
| Re: More Database Design Stuff | Josh Berkus | 22:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Where is the database located in 7.1.2? | Calvin Dodge | 00:06 |
| Re: Knowing new item in table... | Danny Aldham | 00:25 |
| Thread | Author | Time |
|---|---|---|
| Using functions in SQL statements | Allan Engelhardt | 11:04 |
| Creating foreign key constraint to child table? | Allan Engelhardt | 12:49 |
| Re: Creating foreign key constraint to child table? | Allan Engelhardt | 13:03 |
| Re: Creating foreign key constraint to child table? | Stephan Szabo | 19:20 |
| Re: Creating foreign key constraint to child table? | Allan Engelhardt | 19:55 |
| Re: Creating foreign key constraint to child table? | Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков | 21:28 |
| Re: Date Time Functions - ANSI SQL ? | Peter Eisentraut | 21:41 |
| Re: Fuzzy matching? | Peter Eisentraut | 21:47 |
| Inheritance is completely broken [was: Re: Creating foreign key constraint to child table?] | Allan Engelhardt | 21:50 |
| Data type confusion 📎 | Josh Berkus | 22:05 |
| Re: Re: Date Time Functions - ANSI SQL ? 📎 | Josh Berkus | 22:12 |
| Re: Data type confusion | Allan Engelhardt | 22:20 |
| Re: Data type confusion | Tom Lane | 22:45 |
| Re: Data type confusion 📎 | Josh Berkus | 23:00 |
| Re: Re: Data type confusion | Tom Lane | 23:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Data type confusion | Peter Eisentraut | 00:00 |
| Re: Re: Data type confusion | Tom Lane | 00:31 |
| Re: Re: Data type confusion | Peter Eisentraut | 01:33 |
| Re: Re: Data type confusion | Tom Lane | 01:50 |
| Re: Re: Data type confusion 📎 | Josh Berkus | 15:08 |
| Re: Re: Data type confusion | Tom Lane | 15:33 |
| Mirroring the database? | Raymond Chui | 17:35 |
| prob with PERL/Postgres | Kristopher Yates | 19:05 |