Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| pg_restore followed by immediate VACUUM ANALYZE | Bryce Nesbitt | 03:46 |
| Re: pg_restore followed by immediate VACUUM ANALYZE | Tom Lane | 03:55 |
| Re: pg_restore followed by immediate VACUUM ANALYZE 📎 | Bryce Nesbitt | 03:59 |
| Re: pg_restore followed by immediate VACUUM ANALYZE | Tom Lane | 04:04 |
| Thread | Author | Time |
|---|---|---|
| create user xxx with md5 string? | Gerardo Herzig | 18:05 |
| Re: create user xxx with md5 string? | Gerardo Herzig | 19:02 |
| Re: create user xxx with md5 string? | Tom Lane | 19:21 |
| Re: create user xxx with md5 string? | Dmitriy Igrishin | 19:36 |
| Re: create user xxx with md5 string? | Dmitriy Igrishin | 19:38 |
| Thread | Author | Time |
|---|---|---|
| get sequence name from table name | Uwe Maiwald | 16:53 |
| Getting more than one row in UNIQUE fields | Another Trad | 17:24 |
| Re: Getting more than one row in UNIQUE fields | Tom Lane | 17:36 |
| Re: get sequence name from table name | Gerardo Herzig | 18:02 |
| Re: get sequence name from table name | Alvaro Herrera | 19:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Getting more than one row in UNIQUE fields | Jasen Betts | 08:55 |
| Thread | Author | Time |
|---|---|---|
| Query Performance | Postgre Novice | 13:00 |
| Re: Query Performance | tv | 13:53 |
| problems with changing the case of turkish characters | the6campbells | 17:12 |
| Re: problems with changing the case of turkish characters | Tom Lane | 17:28 |
| Re: problems with changing the case of turkish characters | the6campbells | 21:20 |
| Re: problems with changing the case of turkish characters | the6campbells | 21:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Query Performance | Postgre Novice | 07:55 |
| Thread | Author | Time |
|---|---|---|
| constants in 2-column foreign keys or how to design a storage for text-groups ? | Andreas | 00:20 |
| Re: Stalled post to pgsql-sql | sergey kapustin | 10:30 |
| Re: Stalled post to pgsql-sql | Pavel Stehule | 10:33 |
| SQL state 58P01 triggered by a database script execution | aymen marouani | 13:10 |
| Re: SQL state 58P01 triggered by a database script execution | A. Kretschmer | 13:24 |
| Re: SQL state 58P01 triggered by a database script execution | aymen marouani | 13:33 |
| Re: SQL state 58P01 triggered by a database script execution | A. Kretschmer | 13:46 |
| Thread | Author | Time |
|---|---|---|
| Window function trouble | Harald Fuchs | 17:00 |
| Re: Window function trouble | Harald Fuchs | 17:49 |
| Re: Window function trouble | Tom Lane | 18:09 |
| Re: Window function trouble | Harald Fuchs | 21:02 |
| Re: Window function trouble | Tom Lane | 23:08 |
| Thread | Author | Time |
|---|---|---|
| FIND_IN_SET | Michael Eshom | 06:22 |
| Re: constants in 2-column foreign keys or how to design a storage for text-groups ? | Jasen Betts | 08:39 |
| Re: FIND_IN_SET | Pavel Stehule | 08:48 |
| Re: Re: constants in 2-column foreign keys or how to design a storage for text-groups ? | Andreas | 10:20 |
| Re: Window function trouble | Harald Fuchs | 15:40 |
| Is there any function to test for numeric ips? | Oliveiros C, | 16:05 |
| Re: Is there any function to test for numeric ips? | Fernando Hevia | 16:20 |
| Re: Is there any function to test for numeric ips? | Harald Fuchs | 16:23 |
| Re: Is there any function to test for numeric ips? | Fernando Hevia | 16:26 |
| Re: Is there any function to test for numeric ips? | Alvaro Herrera | 16:28 |
| Re: Is there any function to test for numeric ips? | Oliveiros C, | 17:40 |
| Thread | Author | Time |
|---|---|---|
| 8.3/8.4 SQL incompatibility? | Britt Piehler | 17:31 |
| Re: 8.3/8.4 SQL incompatibility? | Tom Lane | 20:23 |
| Thread | Author | Time |
|---|---|---|
| get distinct + group by then filter | Ivan Sergio Borgonovo | 15:28 |
| Thread | Author | Time |
|---|---|---|
| Re: get distinct + group by then filter | Filip RembiaĆkowski | 12:20 |
| Re: get distinct + group by then filter | Ivan Sergio Borgonovo | 13:44 |
| Thread | Author | Time |
|---|---|---|
| 8.4.1 distinct query WITHOUT order by | Gary Chambers | 22:15 |
| Re: 8.4.1 distinct query WITHOUT order by | Thomas Kellerer | 22:38 |
| Re: 8.4.1 distinct query WITHOUT order by | Scott Marlowe | 22:53 |
| Thread | Author | Time |
|---|---|---|
| Re: 8.4.1 distinct query WITHOUT order by | Gary Chambers | 03:45 |
| Re: 8.4.1 distinct query WITHOUT order by | Scott Marlowe | 05:18 |
| Re: 8.4.1 distinct query WITHOUT order by | Scott Marlowe | 05:23 |
| Re: 8.4.1 distinct query WITHOUT order by | msi77 | 07:11 |
| Re: 8.4.1 distinct query WITHOUT order by | Scott Marlowe | 09:22 |
| short-cutting if sum()>constant | Ivan Sergio Borgonovo | 12:35 |
| Re: short-cutting if sum()>constant | Filip RembiaĆkowski | 13:48 |
| Re: short-cutting if sum()>constant | Adam Tauno Williams | 14:02 |
| Re: short-cutting if sum()>constant | A. Kretschmer | 14:12 |
| Re: short-cutting if sum()>constant | msi77 | 15:11 |
| Re: short-cutting if sum()>constant | Ivan Sergio Borgonovo | 17:20 |
| Re: short-cutting if sum()>constant | Andreas Kretschmer | 17:30 |
| Re: short-cutting if sum()>constant | msi77 | 19:15 |
| Re: short-cutting if sum()>constant | Pavel Stehule | 19:47 |
| Re: short-cutting if sum()>constant | Ivan Sergio Borgonovo | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Using || operator to fold multiple columns into one | Craig Ringer | 03:08 |
| Thread | Author | Time |
|---|---|---|
| Invitation to connect on LinkedIn | Mina Waheeb | 16:57 |
| Thread | Author | Time |
|---|---|---|
| Foreign key - Indexing & Deadlocking. | Andrew Hall | 22:59 |
| Re: Using || operator to fold multiple columns into one | Bryce Nesbitt | 23:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Foreign key - Indexing & Deadlocking. | Craig Ringer | 01:18 |
| DataBase Problem | Premila Devi | 01:49 |
| Re: DataBase Problem | Craig Ringer | 01:54 |
| Re: DataBase Problem | Joshua Tolley | 11:42 |
| Re: PSQL statement to delete 100 rows meeting certain criteria | Chris Browne | 21:20 |
| Thread | Author | Time |
|---|---|---|
| loading a file into a field | Brian Sherwood | 16:23 |
| Re: Using || operator to fold multiple columns into one | Rosser Schwarz | 16:23 |
| Proper case function | Michael Gould | 17:36 |
| Re: Proper case function | Gary Chambers | 17:40 |
| Re: loading a file into a field | Tim Landscheidt | 18:15 |
| Re: Proper case function | Michael Gould | 18:17 |
| Re: Proper case function | Tim Landscheidt | 19:27 |
| Re: Proper case function | Seth Gordon | 19:30 |