Discussion for users on SQL related matters.
| Thread | Author | Time | 
|---|---|---|
| generic return for functions | Danny Su | 04:02 | 
| Re: generic return for functions | Avi Schwartz | 05:09 | 
| Re: generic return for functions | Joe Conway | 05:30 | 
| Re: Upgrade 7.2.3 -> 7.3 or more | Rod Taylor | 12:03 | 
| Re: generic return for functions | Rod Taylor | 12:21 | 
| Re: generic return for functions | Avi Schwartz | 15:21 | 
| Re: generic return for functions | Tom Lane | 15:46 | 
| Re: generic return for functions | Avi Schwartz | 16:15 | 
| Re: PostgreSQL and industry | Josh Berkus | 18:35 | 
| Re: generic return for functions | Josh Berkus | 18:45 | 
| Thread | Author | Time | 
|---|---|---|
| SQL problem: bank account | Erik G. Burrows | 05:30 | 
| Re: SQL problem: bank account | Andrew J. Kopciuch | 06:13 | 
| Re: SQL problem: bank account | Sean Chittenden | 06:21 | 
| Re: SQL problem: bank account | listrec | 07:49 | 
| Re: CASE returning multiple values (was SQL Help) | Richard Huxton | 07:51 | 
| Re: SQL problem: bank account | Jonathan Gardner | 13:20 | 
| Using & - operator | Rado Petrik | 13:34 | 
| Re: SQL problem: bank account | Tom Lane | 13:42 | 
| Re: SQL problem: bank account | Dmitry Tkach | 14:28 | 
| Re: Using & - operator | Dmitry Tkach | 14:31 | 
| Maintaining a counter up-to-date | Samuel Tardieu | 15:47 | 
| Re: SQL problem: bank account | Jonathan Gardner | 16:40 | 
| Re: SQL problem: bank account | Erik G. Burrows | 16:58 | 
| Re: Maintaining a counter up-to-date | Richard Huxton | 18:27 | 
| Re: Maintaining a counter up-to-date | Samuel Tardieu | 18:29 | 
| Change owner of function in 7.2.4? | Josh Berkus | 22:49 | 
| Thread | Author | Time | 
|---|---|---|
| How to make a IN without a table... ? | David Pradier | 14:59 | 
| Thread | Author | Time | 
|---|---|---|
| EXTERN JOIN with WHEN query | javier garcia - CEBAS | 10:55 | 
| To ListAdms: Is pgsql-sql operating? | Achilleus Mantzios | 11:39 | 
| simulating partial fkeys.. | mallah | 14:55 | 
| Changing owner of function -- best method? | Josh Berkus | 15:06 | 
| Re: To ListAdms: Is pgsql-sql operating? | Josh Berkus | 16:25 | 
| Re: To ListAdms: Is pgsql-sql operating? | Chad Thompson | 21:28 | 
| Domains and Joins | chester c young | 21:38 | 
| Thread | Author | Time | 
|---|---|---|
| (long) What's the problem? | David Olbersen | 00:45 | 
| Re: To ListAdms: Is pgsql-sql operating? | Joerg Hessdoerfer | 08:30 | 
| Re: simulating partial fkeys.. [ATTN Developers please] 📎 | Richard Huxton | 10:42 | 
| Re: simulating partial fkeys.. | Jan Wieck | 11:35 | 
| Re: simulating partial fkeys.. | Bruno Wolff III | 12:20 | 
| Re: Changing owner of function -- best method? | Tom Lane | 13:52 | 
| Re: Changing owner of function -- best method? | Dmitry Tkach | 14:42 | 
| Creating Views with Column Names based on Distinct Row Data | Damien Dougan | 14:59 | 
| Re: Approved | pgman | 15:37 | 
| Re: simulating partial fkeys.. | Josh Berkus | 15:58 | 
| (long) What's the problem? | David Olbersen | 16:23 | 
| Elegant SQL solution: | Chris Gamache | 16:26 | 
| "Join" on delimeter aggregate query | Michael A Nachbaur | 17:03 | 
| Re: simulating partial fkeys.. [ATTN Developers please] | Stephan Szabo | 17:04 | 
| Using a RETURN NEXT | 22:14 | 
| Thread | Author | Time | 
|---|---|---|
| Re: Column limits in table/ views | Rod Taylor | 13:48 | 
| Re: EXTERN JOIN with WHEN query | Mendola Gaetano | 18:05 | 
| Re: Column limits in table/ views | Gaetano Mendola | 18:08 | 
| Re: "Join" on delimeter aggregate query | Eivind Kvedalen | 21:06 | 
| Re: (long) What's the problem? | Rod Taylor | 23:57 | 
| Thread | Author | Time | 
|---|---|---|
| Re: "Join" on delimeter aggregate query | Joe Conway | 01:03 | 
| Re: Elegant SQL solution: | Josh Berkus | 01:54 | 
| Re: Elegant SQL solution: | greg | 01:58 | 
| Re: How to make a IN without a table... ? | Bruno Wolff III | 11:11 | 
| Re: "Join" on delimeter aggregate query | Bruno Wolff III | 11:37 | 
| Re: Elegant SQL solution: | Ian Barwick | 11:54 | 
| Re: Domains and Joins | Rod Taylor | 12:23 | 
| Re: (long) What's the problem? | Jan Wieck | 15:08 | 
| Re: Using a RETURN NEXT | Joe Conway | 22:33 | 
| Thread | Author | Time | 
|---|---|---|
| Re: "Join" on delimeter aggregate query | Tom Lane | 01:05 | 
| Re: "Join" on delimeter aggregate query | Eivind Kvedalen | 08:35 | 
| Retype | Rado Petrik | 09:24 | 
| Re: Using a RETURN NEXT | Mendola Gaetano | 11:22 | 
| Coalesce/Join/Entries may not exist. | James Taylor | 12:00 | 
| Re: "Join" on delimeter aggregate query | Tom Lane | 14:06 | 
| Re: Creating Views with Column Names based on Distinct | Frank Bax | 14:13 | 
| left join in cursor | Alexey Dashevsky | 14:21 | 
| Re: Column limits in table/ views | Tom Lane | 14:22 | 
| find open transactions/locks in 7.2? | george young | 19:21 | 
| Re: "Join" on delimeter aggregate query | Michael A Nachbaur | 20:08 | 
| how to determine array size | Forest Wilkinson | 20:23 | 
| Thread | Author | Time | 
|---|---|---|
| Re: Retype | Richard Huxton | 07:20 | 
| Re: Coalesce/Join/Entries may not exist. | Rod Taylor | 11:57 | 
| Re: how to determine array size | Rod Taylor | 12:04 | 
| Re: how to determine array size | Achilleus Mantzios | 12:32 | 
| Re: left join in cursor | Tom Lane | 13:35 | 
| Re: "Join" on delimeter aggregate query | Bruno Wolff III | 13:58 | 
| Re: trigger error | Dmitry Tkach | 15:57 | 
| trigger error | Yudie | 16:04 | 
| Re: trigger error | Mendola Gaetano | 16:27 | 
| Re: how to determine array size | Forest Wilkinson | 17:45 | 
| Re: how to determine array size | Rod Taylor | 19:30 | 
| Re: Using a RETURN NEXT | 21:01 | 
| Thread | Author | Time | 
|---|---|---|
| Record size | Hilary Forbes | 08:35 | 
| Re: find open transactions/locks in 7.2? | Christoph Haller | 11:00 | 
| Re: Record size | Tom Lane | 13:11 | 
| Re: Record size | Josh Berkus | 16:18 | 
| Re: Creating Views with Column Names based on Distinct | Guy Fraser | 17:01 | 
| Thread | Author | Time | 
|---|---|---|
| question on rules | weigelt | 01:26 | 
| Re: question on rules | Tom Lane | 01:57 | 
| Re: question on rules | Tomasz Myrta | 06:00 | 
| date question | javier garcia - CEBAS | 11:44 | 
| trigger : emulate "instead of" with before ? | Albrecht Berger | 11:50 | 
| "No such attribute or function 'oid'" | javier garcia - CEBAS | 11:59 | 
| Re: trigger : emulate "instead of" with before ? | Matthew Nuzum | 13:09 | 
| Re: trigger : emulate "instead of" with before ? | Jeff Eckermann | 13:50 | 
| Re: trigger : emulate "instead of" with before ? | Tom Lane | 13:57 | 
| create tables within functions | Demidem Mohamed Amine | 15:07 | 
| Re: create tables within functions | Stephan Szabo | 15:22 | 
| Re: question on rules | Jan Wieck | 16:30 | 
| Re: create tables within functions | chester c young | 19:15 | 
| rpm scripts | Craig Jensen | 19:45 | 
| Re: subselects - which is faster? | scott.marlowe | 21:00 | 
| Re: How to make a IN without a table... ? | scott.marlowe | 21:04 | 
| Thread | Author | Time | 
|---|---|---|
| UNION & LIMIT & ORDER BY | Emmanuel Engelhart | 17:01 | 
| WHERE of an AGGREGATE ... | The Hermit Hacker | 23:31 | 
| Re: WHERE of an AGGREGATE ... | deststar | 23:58 | 
| Thread | Author | Time | 
|---|---|---|
| Re: WHERE of an AGGREGATE ... | The Hermit Hacker | 00:39 | 
| Where of an aggregate | vali | 08:01 | 
| Ordering in an aggregate -- points to paths | Julian Scarfe | 15:13 | 
| Re: Ordering in an aggregate -- points to paths | Tom Lane | 15:49 | 
| Re: Ordering in an aggregate -- points to paths | Julian Scarfe | 16:48 |