Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| independent sequence for each month | Tomasz Myrta | 06:18 |
| Re: Porting from PL/SQL to PLPGSQL | Jomon Skariah | 08:19 |
| Re: Timezone troubles | Tom Lane | 11:20 |
| Re: Timezone troubles | Tom Lane | 11:26 |
| Porting from PL/SQL to PLPGSQL | Jomon Skariah | 13:46 |
| Re: independent sequence for each month | Bruno Wolff III | 14:12 |
| Optional join | Slawek Jarosz | 14:40 |
| Re: [SQL] EXTERNAL storage and substring on long strings | Jan Wieck | 15:02 |
| Re: Changing data type must recreate all views? | Christoph Haller | 15:18 |
| Re: [SQL] EXTERNAL storage and substring on long strings | Tom Lane | 18:00 |
| Re: [SQL] EXTERNAL storage and substring on long strings | Scott Cain | 18:11 |
| Re: How to optimize this query ? | krystoffff | 18:14 |
| Re: [SQL] EXTERNAL storage and substring on long strings | Jan Wieck | 18:55 |
| lower/upper functions and strings in searches | Gregory S. Williamson | 23:46 |
| Thread | Author | Time |
|---|---|---|
| Re: lower/upper functions and strings in searches | Stephan Szabo | 00:00 |
| Re: lower/upper functions and strings in searches | Josh Berkus | 00:17 |
| Re: Optional join | Stephan Szabo | 04:40 |
| Re: Optional join | Bruno Wolff III | 04:57 |
| Re: Optional join | David Fetter | 05:50 |
| sequence | cristi | 09:32 |
| Re: sequence | Bertrand Petit | 10:30 |
| Re: sequence | Dennis Björklund | 10:40 |
| Re: sequence | Tom Lane | 12:01 |
| Re: About primary keys. | Tim Andersen | 14:38 |
| Re: About primary keys. | Tom Lane | 15:57 |
| [Newbie] migrating a stored procedure from MSSQL to postgresql | Bengali | 16:27 |
| Re: How to optimize this query ? | ProgHome | 20:24 |
| Re: About primary keys. | Tim Andersen | 21:32 |
| Thread | Author | Time |
|---|---|---|
| Re: About primary keys -- made some progress | Tim Andersen | 04:15 |
| Do it exist? | Hal Davison | 09:38 |
| Re: About primary keys -- made some progress | Tom Lane | 12:36 |
| Re: Optional join | Ian Barwick | 16:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Do it exist? | Rod Taylor | 02:47 |
| Expression transformation curiosity | Richard Huxton | 10:32 |
| Re: Expression transformation curiosity | Tom Lane | 15:23 |
| Re: Expression transformation curiosity | Alexander M. Pravking | 15:39 |
| Re: Expression transformation curiosity | Richard Huxton | 17:01 |
| Thread | Author | Time |
|---|---|---|
| Reverse pattern match. | Moonstruck | 07:05 |
| Re: Reverse pattern match. | Rod Taylor | 23:05 |
| Re: Reverse pattern match. | Josh Berkus | 23:11 |
| Thread | Author | Time |
|---|---|---|
| Inheritance or no inheritance, there is a question | Vernon Smith | 03:59 |
| Re: Inheritance or no inheritance, there is a question | Josh Berkus | 04:36 |
| Re: Changing data type must recreate all views? | Peter Eisentraut | 07:53 |
| Configuring Problem on Solaris............ | Chidananda | 08:32 |
| postgres 7.1.3: why does the query plan ignore indexes? | Marco Vezzoli | 08:43 |
| Migration from db2 to postgres' 📎 | shyamperi | 10:52 |
| link toward pgsql-sql is missing on the left menu at http://archives.postgresql.org/ | Richard NAGY | 12:26 |
| Re: Migration from db2 to postgres' | Tim Andersen | 12:43 |
| Query problem | Rado Petrik | 13:02 |
| Re: postgres 7.1.3: why does the query plan ignore indexes? | Tom Lane | 13:26 |
| Re: postgres 7.1.3: why does the query plan ignore indexes? | Marco Vezzoli | 13:41 |
| Re: Query problem | Richard Huxton | 14:21 |
| Re: Query problem | Bruno Wolff III | 15:50 |
| Thread | Author | Time |
|---|---|---|
| URGENT : free result (libpq++ API) | Anagha Joshi | 05:57 |
| Re: URGENT : free result (libpq++ API) | Stephan Szabo | 06:11 |
| Re: "SELECT IN" Still Broken in 7.4b | Oleg Bartunov | 07:38 |
| Re: "SELECT IN" Still Broken in 7.4b | Dani Oderbolz | 10:05 |
| Re: "SELECT IN" Still Broken in 7.4b | Stephan Szabo | 17:28 |
| Re: [SQL] "SELECT IN" Still Broken in 7.4b | Tom Lane | 20:42 |
| Re: [SQL] "SELECT IN" Still Broken in 7.4b | Stephan Szabo | 21:07 |
| Re: [SQL] "SELECT IN" Still Broken in 7.4b | Manfred Koizar | 21:18 |
| Re: [SQL] "SELECT IN" Still Broken in 7.4b | Josh Berkus | 21:19 |
| Re: [SQL] "SELECT IN" Still Broken in 7.4b | Tom Lane | 21:46 |
| Re: [SQL] "SELECT IN" Still Broken in 7.4b | Joe Conway | 22:01 |
| Re: [SQL] "SELECT IN" Still Broken in 7.4b | Tom Lane | 22:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Delete denied? | Stephan Szabo | 01:22 |
| Auto-update a field when record is changed | Stuart | 03:32 |
| Re: Auto-update a field when record is changed | Stephan Szabo | 04:53 |
| Re: Auto-update a field when record is changed | Jamie Lawrence | 05:16 |
| Re: Joined deletes but one table being a subquery. | Rajesh Kumar Mallah | 09:30 |
| Re: Delete denied? | Jeff Eckermann | 16:55 |
| Thread | Author | Time |
|---|---|---|
| Equality operators on NULL values | Bertrand Petit | 01:28 |
| Re: Equality operators on NULL values | Peter Eisentraut | 08:43 |
| Re: Which cursor-related warnings should be errors? | Peter Eisentraut | 21:10 |
| Re: [SQL] "SELECT IN" Still Broken in 7.4b | Tom Lane | 21:37 |
| Re: "SELECT IN" Still Broken in 7.4b | Tom Lane | 21:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Joined deletes but one table being a subquery. | Tomasz Myrta | 05:59 |
| Re: [ZODB-Dev] What are the ZopeDB limit? | Michele Bendazzoli | 07:12 |
| Re: [ZODB-Dev] What are the ZopeDB limit? | Michele Bendazzoli | 07:16 |
| Strange behavior with timestamptz | George Weaver | 18:18 |
| Re: Strange behavior with timestamptz | Tom Lane | 20:59 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres 7.1.3: why does the query plan ignore indexes? | Bruce Momjian | 04:22 |
| Re: postgres 7.1.3: why does the query plan ignore indexes? | Tom Lane | 04:27 |
| How to return a record set from function. | Kumar | 07:18 |
| Canceling other backend's query | daq | 09:12 |
| [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? | Marco Vezzoli | 11:47 |
| Re: Restore deleted records | Bruno Wolff III | 12:36 |
| script to create a sample database | Popeanga Marian | 13:04 |
| Re: How to return a record set from function. | Richard Huxton | 13:50 |
| Re: Canceling other backend's query | Bruce Momjian | 14:46 |
| Re: How to return a record set from function. | Stephan Szabo | 15:11 |
| Q: Multicolumn lookup, Join or Sub-query ? | Richard A. DeVenezia | 15:30 |
| Re: Canceling other backend's query | scott.marlowe | 15:31 |
| length of array | Chris Faulkner | 19:49 |
| Re: One-2-many relation - need distinct counts | Richard Huxton | 19:51 |
| Thread | Author | Time |
|---|---|---|
| Re: length of array | Joe Conway | 00:40 |
| Re: How to optimize this query ? | ProgHome | 01:01 |
| Re: How to return a record set from function. | Joe Conway | 01:02 |
| Re: How to optimize this query ? | Stephan Szabo | 01:18 |
| Re: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? | Bruno Wolff III | 03:19 |
| Re: smallfloat with postgresql | Bruno Wolff III | 03:42 |
| lock row in table | Daniel Michał | 08:23 |
| Re: lock row in table | Yudha Setiawan | 10:42 |
| Re: lock row in table | Daniel | 12:14 |
| interval conversion | Brett Dikeman | 13:23 |
| Re: lock row in table | Tom Lane | 13:38 |
| Re: length of array | Chris Faulkner | 14:37 |
| Re: interval conversion | Tomasz Myrta | 14:40 |
| Re: interval conversion | Brett Dikeman | 15:45 |
| Re: length of array | Joe Conway | 21:27 |
| BEFORE UPDATE Triggers | Chris Anderson | 21:48 |
| Forcing a trigger to run | Michael A Nachbaur | 22:47 |
| Re: How to join from two tables at once? | Joseph Shraibman | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Migrating Stored Procedures from MS SQL Server | Kumar | 05:24 |
| Re: Migrating Stored Procedures from MS SQL Server | David Witham | 05:31 |
| Unique constraints for a list | Anuradha Ratnaweera | 05:50 |
| Re: [SQL] Unique constraints for a list | Richard Huxton | 08:52 |
| Select Match on PostgreSQL. 📎 | Laurent Patureau | 10:41 |
| Re: Select Match on PostgreSQL. | Oleg Bartunov | 12:29 |
| Thread | Author | Time |
|---|---|---|
| Re: BEFORE UPDATE Triggers | Jan Wieck | 02:50 |
| Getting the return type right for SETOF | Dan Langille | 20:42 |
| Re: Getting the return type right for SETOF | Stephan Szabo | 20:59 |
| Re: BEFORE UPDATE Triggers | Tom Lane | 21:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Getting the return type right for SETOF | Dan Langille | 01:16 |