Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Fwd: i want small information regarding postgres | Tim Landscheidt | 17:01 |
| Thread | Author | Time |
|---|---|---|
| Re: compare table names | Brice André | 06:43 |
| Re: compare table names | Tony Capobianco | 14:29 |
| amount of join's and sequential access to the tables involved | Gerardo Herzig | 15:36 |
| Re: amount of join's and sequential access to the tables involved | Tom Lane | 15:40 |
| Re: amount of join's and sequential access to the tables involved | Gerardo Herzig | 16:06 |
| Re: amount of join's and sequential access to the tables involved | Tom Lane | 16:14 |
| Unable To Alter Data Type | Carlos Mennens | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Unable To Alter Data Type | David Johnston | 00:13 |
| Re: Unable To Alter Data Type | Carlos Mennens | 00:30 |
| Re: Unable To Alter Data Type | David Johnston | 01:21 |
| Re: amount of join's and sequential access to the tables involved | Gerardo Herzig | 14:09 |
| Unable To Modify Table | Carlos Mennens | 16:42 |
| Re: Unable To Modify Table | Steve Crawford | 16:53 |
| Re: Unable To Modify Table | Adrian Klaver | 16:54 |
| Re: Unable To Modify Table | David Johnston | 16:56 |
| Re: Unable To Modify Table | David Johnston | 17:02 |
| Re: Unable To Modify Table | Adrian Klaver | 17:10 |
| Thread | Author | Time |
|---|---|---|
| Query Problem... Left OuterJoin / Tagging Issue | John Tuliao | 04:31 |
| Re: Query Problem... Left OuterJoin / Tagging Issue | David Johnston | 14:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Unable To Modify Table | Gavin Flower | 08:20 |
| sql query problem | Alok Thakur | 09:18 |
| Thread | Author | Time |
|---|---|---|
| Token separation | Tim Landscheidt | 08:02 |
| Re: Token separation | Tom Lane | 17:15 |
| Call function with dynamic schema name | IlGenna | 17:28 |
| Re: Call function with dynamic schema name | Pavel Stehule | 17:33 |
| Re: Call function with dynamic schema name | IlGenna | 17:37 |
| Re: Call function with dynamic schema name | Pavel Stehule | 18:27 |
| Re: sql query problem | Oliveiros | 21:13 |
| Re: Call function with dynamic schema name | Misa Simic | 22:36 |
| Re: sql query problem | Misa Simic | 22:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Query Problem... Left OuterJoin / Tagging Issue | John Tuliao | 08:43 |
| Re: sql query problem | Alok Thakur | 09:48 |
| Re: Token separation | Tim Landscheidt | 15:12 |
| Thread | Author | Time |
|---|---|---|
| UPDATE COMPATIBILITY | Gera Mel Handumon | 06:31 |
| Wrong query plan when using a left outer join | Feike Steenbergen | 06:54 |
| Re: UPDATE COMPATIBILITY | Thomas Kellerer | 08:49 |
| Re: Wrong query plan when using a left outer join | Filip Rembiałkowski | 11:53 |
| Re: sql query problem | Andreas Kretschmer | 13:35 |
| Re: sql query problem | David Johnston | 14:05 |
| Re: UPDATE COMPATIBILITY | Adrian Klaver | 15:19 |
| Re: UPDATE COMPATIBILITY | Thomas Kellerer | 16:28 |
| Re: Wrong query plan when using a left outer join | Feike Steenbergen | 18:53 |
| Re: Wrong query plan when using a left outer join | Feike Steenbergen | 18:55 |
| Re: Wrong query plan when using a left outer join | Rosser Schwarz | 19:13 |
| Thread | Author | Time |
|---|---|---|
| Re: UPDATE COMPATIBILITY | Samuel Gendler | 07:22 |
| Postgresql Function | Rehan Saleem | 09:03 |
| PostgreSQL Function | Rehan Saleem | 09:10 |
| Re: PostgreSQL Function | Pavel Stehule | 09:25 |
| Thread | Author | Time |
|---|---|---|
| date range to set of dates expansion | Gary Stainburn | 07:13 |
| Re: date range to set of dates expansion | hari.fuchs | 08:32 |
| how to return whole table from Function not just the id integer column | Rehan Saleem | 09:57 |
| Re: how to return whole table from Function not just the id integer column | Samuel Gendler | 10:33 |
| Re: date range to set of dates expansion | Gary Stainburn | 15:11 |
| Re: date range to set of dates expansion | Gary Stainburn | 15:16 |
| Re: date range to set of dates expansion | Gary Stainburn | 15:59 |
| Re: SOLVED - date range to set of dates expansion | Gary Stainburn | 16:10 |
| Re: date range to set of dates expansion | Adrian Klaver | 16:20 |
| Re: date range to set of dates expansion | Steve Crawford | 16:50 |
| Re: date range to set of dates expansion | Samuel Gendler | 17:17 |
| Re: date range to set of dates expansion | Gary Stainburn | 17:27 |
| Re: date range to set of dates expansion | Adrian Klaver | 19:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Token separation | Jasen Betts | 13:29 |
| Thread | Author | Time |
|---|---|---|
| How to Return Table From Function | Rehan Saleem | 13:09 |
| Re: How to Return Table From Function | Pavel Stehule | 13:53 |
| Re: How to Return Table From Function | Rob Sargentg | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Problem with sequence increment | Francisco Calderón | 14:12 |
| Re: Problem with sequence increment | Brice André | 14:31 |
| Re: Problem with sequence increment | [email protected] | 14:31 |
| Thread | Author | Time |
|---|---|---|
| Query question | John Tuliao | 12:00 |
| Update Mass Data in Field? | Carlos Mennens | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Update Mass Data in Field? | Steve Crawford | 00:06 |
| Re: Update Mass Data in Field? | David Johnston | 00:20 |
| Re: Getting a list of a table's attributes that are sortable sorted by uniqueness | Tim Landscheidt | 02:13 |
| Re: Query question | Lew | 19:04 |
| Thread | Author | Time |
|---|---|---|
| MS-SQL Store Procedure to Postgresql Function | Rehan Saleem | 06:42 |
| querying a column w/ timestamp with timezone datatype | Anson Abraham | 15:00 |
| Re: querying a column w/ timestamp with timezone datatype | Steve Crawford | 18:09 |
| Thread | Author | Time |
|---|---|---|
| pg_dump not correctly saving schema with partitioned tables? | chester c young | 13:17 |
| must appear in the GROUP BY clause or be used in an aggregate function problem | Edward W. Rouse | 20:27 |
| Re: must appear in the GROUP BY clause or be used in an aggregate function problem | David Johnston | 20:48 |
| Re: must appear in the GROUP BY clause or be used in an aggregate function problem | Samuel Gendler | 20:57 |
| Re: pg_dump not correctly saving schema with partitioned tables? | Tom Lane | 21:04 |
| Re: must appear in the GROUP BY clause or be used in an aggregate function problem | Edward W. Rouse | 21:26 |
| Re: must appear in the GROUP BY clause or be used in an aggregate function problem | Edward W. Rouse | 21:43 |
| Re: must appear in the GROUP BY clause or be used in an aggregate function problem | Samuel Gendler | 21:51 |
| Re: must appear in the GROUP BY clause or be used in an aggregate function problem | Edward W. Rouse | 22:13 |
| Thread | Author | Time |
|---|---|---|
| Fw: Re: pg_dump not correctly saving schema with partitioned tables? | chester c young | 00:42 |
| Display Length Between Var & Varchar | Carlos Mennens | 04:08 |
| Re: Display Length Between Var & Varchar | Adrian Klaver | 04:13 |
| Re: Fw: Re: [SQL] pg_dump not correctly saving schema with partitioned tables? | Tom Lane | 04:47 |
| Re: MS-SQL Store Procedure to Postgresql Function | Jasen Betts | 10:52 |
| Thread | Author | Time |
|---|---|---|
| Multiple tables query on Mapserver | tiplip | 05:16 |
| Re: Multiple tables query on Mapserver | David Johnston | 05:22 |
| Re: Multiple tables query on Mapserver | tiplip | 05:32 |
| Re: Multiple tables query on Mapserver | David Johnston | 05:45 |
| Re: Multiple tables query on Mapserver | tiplip | 07:58 |
| Re: MS-SQL Store Procedure to Postgresql Function | F. BROUARD / SQLpro | 21:00 |
| Re: MS-SQL Store Procedure to Postgresql Function | Pavel Stehule | 21:20 |
| Thread | Author | Time |
|---|---|---|
| array dimensions, pg_catalog.pg_attribute and the \d command | Achilleas Mantzios | 15:41 |
| Re: array dimensions, pg_catalog.pg_attribute and the \d command | Dmitriy Igrishin | 20:21 |
| Thread | Author | Time |
|---|---|---|
| Is there a way to remove every character but numbers? | Andreas | 13:47 |
| Re: Is there a way to remove every character but numbers? | Viktor Bojović | 13:56 |
| Thread | Author | Time |
|---|---|---|
| type cast about int to bit | zoulx1982 | 06:11 |
| Re: array dimensions, pg_catalog.pg_attribute and the \d command | Achilleas Mantzios | 08:42 |
| Re: type cast about int to bit | Jasen Betts | 11:05 |
| Thread | Author | Time |
|---|---|---|
| Re: type cast about int to bit | Adrian Klaver | 01:19 |
| Re: type cast about int to bit | Adrian Klaver | 03:28 |
| problem with nested dblink function | Bear | 14:00 |
| Thread | Author | Time |
|---|---|---|
| update multiple columns with multiple values | ssylla | 07:39 |
| Re: problem with nested dblink function | Bear | 07:48 |
| Concurrent Reindex on Primary Key for large table | rverghese | 18:07 |
| Re: Concurrent Reindex on Primary Key for large table | Thomas Kellerer | 18:28 |
| time interval math | Edward W. Rouse | 20:01 |
| Re: time interval math | Steve Crawford | 20:25 |
| Re: time interval math | Edward W. Rouse | 20:49 |
| Thread | Author | Time |
|---|---|---|
| Re: time interval math | Tim Landscheidt | 01:51 |
| update column | ssylla | 01:58 |
| update column with multiple values | ssylla | 02:31 |
| Re: time interval math | Jasen Betts | 11:36 |
| Re: time interval math | Edward W. Rouse | 14:31 |
| Re: Concurrent Reindex on Primary Key for large table | rverghese | 17:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Concurrent Reindex on Primary Key for large table | Igor Neyman | 14:41 |
| Re: update column | Oliveiros d'Azevedo Cristina | 15:33 |
| Re: update column with multiple values | David Johnston | 16:08 |
| Thread | Author | Time |
|---|---|---|
| Re: time interval math | Jasen Betts | 03:18 |
| Calling Postgresql Function to delete user data | Rehan Saleem | 19:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Calling Postgresql Function to delete user data | Philip Couling | 13:02 |
| Thread | Author | Time |
|---|---|---|
| foreign key is it a real key | John Fabiani | 15:46 |
| Re: foreign key is it a real key | Andreas Kretschmer | 15:50 |
| Re: foreign key is it a real key | John Fabiani | 17:30 |
| Thread | Author | Time |
|---|---|---|
| need help with import | Andreas | 01:02 |
| Re: need help with import | David Johnston | 01:13 |
| Re: need help with import | Andreas | 02:05 |
| Re: need help with import | David Johnston | 02:41 |
| Re: need help with import | Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) | 02:55 |
| pg_dump - 8.3 - schemas | Edward W. Rouse | 18:59 |
| Re: pg_dump - 8.3 - schemas | Adrian Klaver | 19:21 |
| Re: pg_dump - 8.3 - schemas | Edward W. Rouse | 19:31 |
| Re: pg_dump - 8.3 - schemas | Adrian Klaver | 19:38 |
| Re: pg_dump - 8.3 - schemas | Edward W. Rouse | 20:17 |
| Re: pg_dump - 8.3 - schemas | Adrian Klaver | 20:22 |
| Thread | Author | Time |
|---|---|---|
| Window function frame clause | vpapavas | 01:01 |
| Re: Window function frame clause | David Johnston | 01:33 |
| cast type bytea to double precision | Amila Jayasooriya | 07:10 |
| cast type bytea to double precision | Amila Jayasooriya | 07:19 |
| How can I use this subselect properly in an update? | John Tuliao | 07:52 |
| hstore and populate_record | Jan Eskilsson | 12:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Window function frame clause | vpapavas | 02:52 |
| Thread | Author | Time |
|---|---|---|
| How to split up phone numbers? | Andreas | 14:50 |
| Re: How to split up phone numbers? | Filip Rembiałkowski | 15:17 |
| Thread | Author | Time |
|---|---|---|
| Function definitions - batch update | Marcin Krawczyk | 07:28 |
| Re: Function definitions - batch update | Tom Lane | 15:15 |
| on insert rule with default value | Ron Peterson | 20:51 |
| Re: How to split up phone numbers? | Tim Landscheidt | 21:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Function definitions - batch update | Marcin Krawczyk | 07:02 |
| Another constant in foreign key problem. | Gary Stainburn | 10:35 |
| Re: Another constant in foreign key problem. | Oliveiros d'Azevedo Cristina | 11:18 |
| Re: Another constant in foreign key problem. | Gary Stainburn | 11:25 |
| Re: Another constant in foreign key problem. | Philip Couling | 12:04 |
| Re: Another constant in foreign key problem. | Gary Stainburn | 12:19 |
| Re: on insert rule with default value | Ron Peterson | 13:52 |
| Re: on insert rule with default value | Adrian Klaver | 15:32 |
| Re: Concurrent Reindex on Primary Key for large table | rverghese | 21:07 |
| Thread | Author | Time |
|---|---|---|
| Re: How to split up phone numbers? | Jasen Betts | 09:14 |
| Thread | Author | Time |
|---|---|---|
| crosstab help | John Fabiani | 08:11 |
| Re: crosstab help | Andreas Gaab | 08:27 |
| Re: crosstab help | John Fabiani | 08:39 |
| Re: crosstab help | Andreas Gaab | 08:48 |
| Re: crosstab help | John Fabiani | 08:56 |
| crosstab maybe by case statement | John Fabiani | 16:32 |
| Thread | Author | Time |
|---|---|---|
| Problems with ODBC connections | Sandeep Reddy | 18:05 |
| Thread | Author | Time |
|---|---|---|
| SQL View to PostgreSQL View | Rehan Saleem | 18:50 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL View to PostgreSQL View | Adrian Klaver | 14:13 |
| Re: Problems with ODBC connections | Adrian Klaver | 14:17 |
| Thread | Author | Time |
|---|---|---|
| array_agg order by | jdmorgan | 03:50 |
| Re: array_agg order by | Tom Lane | 04:15 |
| How to convert SQL store procedure to Postgresql function | Rehan Saleem | 08:50 |
| Re: How to convert SQL store procedure to Postgresql function | Filip Rembiałkowski | 10:36 |
| Re: SQL View to PostgreSQL View | Mario Dankoor | 11:29 |
| Re: How to convert SQL store procedure to Postgresql function | Rehan Saleem | 11:56 |
| Re: How to convert SQL store procedure to Postgresql function | Rehan Saleem | 12:00 |
| Re: How to convert SQL store procedure to Postgresql function | Leif Biberg Kristensen | 12:22 |
| Re: Natural sort order | Richard Klingler | 12:38 |
| Re: SQL View to PostgreSQL View | Igor Neyman | 14:27 |
| Thread | Author | Time |
|---|---|---|
| custom_variable_classes in 9.1 | Marcin Krawczyk | 09:29 |
| How to shrink database in postgresql | Rehan Saleem | 09:49 |
| Re: How to shrink database in postgresql | Pavel Stehule | 09:56 |
| Re: custom_variable_classes in 9.1 | Marcin Krawczyk | 10:04 |
| Re: Natural sort order | Tom Lane | 16:08 |
| Re: Natural sort order | Richard Klingler | 16:14 |
| date arithmetic with columns | Peter Faulks | 19:50 |
| Re: date arithmetic with columns | Peter Faulks | 23:21 |
| Thread | Author | Time |
|---|---|---|
| No sort with except | reto.buchli | 08:13 |
| Re: No sort with except | Frank Lanitz | 08:16 |
| Re: No sort with except | reto.buchli | 08:56 |
| Re: No sort with except | Jasen Betts | 09:19 |
| Re: No sort with except | Philip Couling | 09:30 |
| Aggregate and join problem | Swärd Mårten | 10:30 |
| Re: Aggregate and join problem | Oliveiros d'Azevedo Cristina | 10:49 |