Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Anyone recognise this error from PL/pgSQL? | Stuart Rison | 08:59 |
| Re: [SQL] Stepping through a table. | Herouth Maoz | 09:19 |
| unsuscribe | Dionisio Barrantes | 09:55 |
| Re: [SQL] Anyone recognise this error from PL/pgSQL? | Tom Lane | 14:12 |
| Re: [SQL] Anyone recognise this error from PL/pgSQL? | Stuart Rison | 14:57 |
| Re: [SQL] Anyone recognise this error from PL/pgSQL? | Herouth Maoz | 15:52 |
| datediff function | Pham, Thinh | 16:02 |
| Re: [SQL] Anyone recognise this error from PL/pgSQL? | Tom Lane | 17:35 |
| Re: [SQL] Anyone recognise this error from PL/pgSQL? | Stuart Rison | 18:28 |
| Re: [SQL] Anyone recognise this error from PL/pgSQL? | Mark Dalphin | 19:28 |
| Re: [SQL] Stepping through a table. | Matthew Hagerty | 20:52 |
| example of a simple function | Clayton Cottingham | 23:09 |
| Re: [SQL] example of a simple function | Bruce Momjian | 23:20 |
| Re: [SQL] datediff function | [email protected] | 23:26 |
| Re: [SQL] example of a simple function | Clayton Cottingham | 23:41 |
| Thread | Author | Time |
|---|---|---|
| defragmentation 📎 | Stanley Morgan | 00:19 |
| Re: [SQL] example of a simple function] | Bruce Momjian | 00:23 |
| RE: [SQL] defragmentation | Michael J Davis | 00:41 |
| Re: [SQL] defragmentation 📎 | Stanley Morgan | 02:56 |
| (no subject) 📎 | Stanley Morgan | 02:58 |
| Random function ? | Zsolt Varga | 05:55 |
| Re: [SQL] datediff function | Herouth Maoz | 11:05 |
| Re: [SQL] Stepping through a table. | Herouth Maoz | 11:13 |
| RE: [SQL] datediff function | Pham, Thinh | 13:18 |
| RE: [SQL] datediff function | Herouth Maoz | 13:28 |
| Re: [SQL] datediff function | Tom Lane | 13:34 |
| RE: [SQL] datediff function | Pham, Thinh | 14:37 |
| RE: [SQL] datediff function | Herouth Maoz | 15:24 |
| RE: [SQL] datediff function | John Ridout | 15:45 |
| Re: [SQL] index on more-than-one columns? | Tom Lane | 21:04 |
| CASE statement causes unknown node type 723 | Nathan Angelacos | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Using intersect in subquery | Hamid Khoshnevis | 00:48 |
| Using intersect in subquery | Hamid Khoshnevis | 01:55 |
| Re: [SQL] Using intersect in subquery | Bruce Momjian | 02:38 |
| Re: [SQL] index on more-than-one columns? | Oleg Bartunov | 05:06 |
| Re: [SQL] CASE statement causes unknown node type 723 | Tom Lane | 13:43 |
| Re: [SQL] Using intersect in subquery | Tom Lane | 13:51 |
| Re: [SQL] Using intersect in subquery | Herouth Maoz | 14:21 |
| Re: [SQL] Using intersect in subquery | Bruce Momjian | 15:10 |
| Counting the number of distinct rows returned | Drew Whittle | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Problems using count() with a join | Doug Younger | 02:10 |
| Re: [SQL] Counting the number of distinct rows returned | [email protected] | 05:20 |
| What JDBC datatype can be used for DATETIME ? | Jon Bundesen | 11:23 |
| Re: [SQL] Problems using count() with a join | Tom Lane | 13:16 |
| does LIMIT save time? | Dirk Lutzebaeck | 13:17 |
| Re: [SQL] Counting the number of distinct rows returned | Tom Lane | 13:18 |
| Re: [SQL] Counting the number of distinct rows returned | Sejin Oh | 13:56 |
| (pas d'objet) | KOUL Christian | 14:01 |
| selecting newer rows | Carlos Henrique Righetto Moreira | 14:30 |
| What JDBC datatype can be used for DATETIME ? | Jon Windfeld Bundesen | 15:42 |
| searching time arrays | Nathan Gelbard | 18:37 |
| Re: [SQL] searching time arrays | Tom Lane | 19:17 |
| multiple keyword search | Mike Field | 21:11 |
| Re: [SQL] does LIMIT save time? | Jan Wieck | 21:24 |
| RE: [SQL] Using intersect in subquery | Hamid Khoshnevis | 21:28 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] What JDBC datatype can be used for DATETIME ? | Esteban Chiner Sanz | 06:47 |
| Re: [SQL] does LIMIT save time? | Dirk Lutzebaeck | 08:13 |
| generate random unique object id | Eric Enockson | 14:01 |
| Re: BOUNCE [email protected]: Non-member submission from [Eric Enockson <[email protected]>] | Eric Enockson | 16:13 |
| generate random unique object id | Eric Enockson | 16:23 |
| Missing PL/pgSQL library | Nicolas Cadou | 17:00 |
| OID and PL/pgSQL trigger :-( | Alke | 20:51 |
| Array-fields and many-to-many relations | Alke | 21:28 |
| is this possible, maybe a todo ? function related | Clayton Cottingham | 23:07 |
| Re: [SQL] is this possible, maybe a todo ? function related | Roderick A. Anderson | 23:13 |
| 2 million+ entries | Matthew Hixson | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] is this possible, maybe a todo ? function related | Zalman Stern | 00:05 |
| Question about comments | Gordon Clarke | 00:58 |
| Re: [SQL] Missing PL/pgSQL library | Nicolas Cadou | 01:10 |
| Re: [SQL] Question about comments | Tom Lane | 03:34 |
| Re: [SQL] is this possible, maybe a todo ? function related | Clayton Cottingham | 05:10 |
| permissions lost: | Clayton Cottingham | 05:29 |
| can i send without being a member | Eric Enockson | 10:17 |
| Re: [SQL] UNIQUE constraint | Mihai Barbos | 15:01 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] What JDBC datatype can be used for DATETIME ? | Herouth Maoz | 12:22 |
| Re: [SQL] Counting the number of distinct rows returned | Herouth Maoz | 12:44 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] selecting newer rows | José Soares | 13:15 |
| Re: [SQL] is this possible, maybe a todo ? function related | Dr. Nisai Wanakule | 13:27 |
| Expression with aggregate | Albert REINER | 13:42 |
| Re: [SQL] UNIQUE constraint | Tom Lane | 14:01 |
| Re: [HACKERS] RE: [SQL] datediff function | José Soares | 14:02 |
| PostgreSQL locking problem (II) | Steffen E. Thorkildsen | 15:06 |
| Re: [SQL] Expression with aggregate | Scott Barron | 22:28 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Question about comments | Bruce Momjian | 04:07 |
| Re: [SQL] Expression with aggregate | Bruce Momjian | 04:24 |
| bytea 📎 | Stanley Morgan | 05:34 |
| Re: [SQL] 2 million+ entries | Michael Richards | 06:30 |
| Re: [SQL] 2 million+ entries | Matthew Hixson | 07:28 |
| Re: [SQL] 2 million+ entries | Moray McConnachie | 08:06 |
| Re: [SQL] 2 million+ entries | Rudy Gireyev | 08:24 |
| Accessing to a granted table. 📎 | Roberto Perez Lita | 09:17 |
| out of memory error on dumping over 1,000,000 to file | Clayton Cottingham | 10:00 |
| Remove | Drinks, Ivan - ITD | 11:51 |
| Re: [SQL] Expression with aggregate | José Soares | 13:37 |
| RE: [SQL] Accessing to a granted table. | Greg Youngblood | 15:38 |
| Dumping Oracle tables into Postgres | Esteban Chiner Sanz | 16:34 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] 2 million+ entries | Michael Richards | 01:25 |
| (no subject) 📎 | Stanley Morgan | 05:54 |
| PgSQL 6.5.1 and Group BY pb | Giampiero Raschetti | 11:08 |
| Re: [SQL] PgSQL 6.5.1 and Group BY pb | Herouth Maoz | 12:58 |
| Re: [SQL] Dumping Oracle tables into Postgres | Howie | 13:29 |
| Re: [SQL] PgSQL 6.5.1 and Group BY pb | Tom Lane | 14:07 |
| Re: [SQL] PgSQL 6.5.1 and Group BY pb | Giampiero Raschetti | 14:12 |
| harddisk crash | Heiko Wilms | 14:42 |
| Re: [SQL] 2 million+ entries | G. Anthony Reina | 16:59 |
| Re: [SQL] 2 million+ entries | Bruce Momjian | 17:19 |
| Re: [SQL] harddisk crash | [email protected] | 17:42 |
| Re: [SQL] Dumping Oracle tables into Postgres | [email protected] | 17:50 |
| Re: [SQL] PgSQL 6.5.1 and Group BY pb | Albert REINER | 20:51 |
| Re: [SQL] more info on ..out of memory error on dumping over 1, 000, 000 to file | Clayton Cottingham | 21:04 |
| Thread | Author | Time |
|---|---|---|
| OT: Pros and cons about using POSTGRESQL and MYSQL | Hector M Banda | 03:13 |
| Re: [SQL] OT: Pros and cons about using POSTGRESQL and MYSQL | Bruce Momjian | 04:12 |
| Re: [SQL] OT: Pros and cons about using POSTGRESQL and MYSQL | Chris Bitmead | 04:38 |
| Re: [SQL] 2 million+ entries | Michael Richards | 05:48 |
| Re: [SQL] 2 million+ entries | Michael Richards | 06:28 |
| money format | Haris Susanto | 08:37 |
| join expression support in 6.5.1? | Brandon Huey | 09:51 |
| replication.. | Safa Pilavcı | 11:14 |
| Doubts in timespan | Paulo Roberto Kappke | 13:23 |
| RE: [SQL] 2 million+ entries | Greg Youngblood | 18:05 |
| Re: [SQL] Missing PL/pgSQL library | Nicolas Cadou | 20:17 |
| Inheritance and DELETE | Enrico Scholz | 22:23 |
| Thread | Author | Time |
|---|---|---|
| datetime query issue | Frank Joerdens | 13:35 |
| Re: [SQL] datetime query issue | [email protected] | 18:23 |
| Re: [SQL] datetime query issue | Frank Joerdens | 18:41 |
| Thread | Author | Time |
|---|---|---|
| SELECT multiple tables with same fields | Dipl.-Ing. Thomas Schallar | 00:24 |
| LEFT or RIGHT JOINs? | Dipl.-Ing. Thomas Schallar | 00:39 |
| entries in pg_shadow | Michael Richards | 00:40 |
| Re: [SQL] indexes using datetime | Tom Lane | 00:46 |
| Re: [HACKERS] entries in pg_shadow | Tom Lane | 01:00 |
| SELECT multiple tables with same fields | Dipl.-Ing. Thomas Schallar | 15:43 |
| LEFT or RIGHT JOINs? | Dipl.-Ing. Thomas Schallar | 15:43 |
| Re: [SQL] SELECT multiple tables with same fields | Tom Lane | 17:02 |
| Thread | Author | Time |
|---|---|---|
| Rules Question | Charles Tassell | 11:20 |
| problem with select | Holm Tiffe | 12:04 |
| Questions about vacuum analyze | Steven M. Wheeler | 12:36 |
| Re: [SQL] datetime query issue | José Soares | 13:04 |
| Re: [SQL] Questions about vacuum analyze | Tom Lane | 14:20 |
| Re: [SQL] problem with select | Tom Lane | 14:43 |
| Re: [SQL] Doubts in timespan | Herouth Maoz | 15:19 |
| Re: [SQL] problem with select | [email protected] | 16:47 |