Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Help with a seq scan on multi-million row table | Andrew Sullivan | 17:18 |
| Re: Help with a seq scan on multi-million row table | ogjunk-pgjedan | 18:46 |
| Thread | Author | Time |
|---|---|---|
| help..postgresql mulyiple return values | Michael Joseph Tan | 10:38 |
| Re: R: Re: R: R: Re: schema inspection | Emi Lu | 20:57 |
| Thread | Author | Time |
|---|---|---|
| PL/PGSQL - How to pass in variables? | Scott Yohonn | 15:28 |
| Re: PL/PGSQL - How to pass in variables? | Jean-Paul Argudo | 15:44 |
| Re: PL/PGSQL - How to pass in variables? | Jaime Casanova | 16:16 |
| Re: PL/PGSQL - How to pass in variables? | Jean-Paul Argudo | 18:50 |
| insert related data into two tables | filippo2991 | 21:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Find min and max values across two columns? | Emi Lu | 21:40 |
| Re: Find min and max values across two columns? | Scott Marlowe | 21:50 |
| MySQL DB to PostgresSQL DB | Jose Apablaza | 22:19 |
| Re: MySQL DB to PostgresSQL DB | Jeff MacDonald | 23:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Find min and max values across two columns? | Tom Lane | 00:08 |
| how referencing %rowtype variables without column names | lingyu.tseng | 04:05 |
| Re: MySQL DB to PostgresSQL DB | Jose Apablaza | 08:45 |
| Re: Find min and max values across two columns? | Emi Lu | 14:44 |
| table constraint + INSERT | Risto Tamme | 21:01 |
| Thread | Author | Time |
|---|---|---|
| Question about SQL Control Structure(if then, for loop) | Jay Chiu | 01:51 |
| Database OID | Kis János Tamás | 06:10 |
| Table constraints and INSERT | Risto Tamme | 06:42 |
| Re: Database OID | Achilleus Mantzios | 07:51 |
| Re: Database OID | Kis János Tamás | 08:01 |
| Recursive SELECT problem | Dave Page | 10:42 |
| Re: Table constraints and INSERT | Niklas Johansson | 10:49 |
| Re: Recursive SELECT problem | Tom Lane | 14:06 |
| Re: Recursive SELECT problem | Dave Page | 14:10 |
| Re: Table constraints and INSERT | Tom Lane | 14:12 |
| Add column and specify the column position in a table | Emi Lu | 21:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Encryption functions | Thusitha Kodikara | 02:43 |
| Re: Encryption functions | Thusitha Kodikara | 02:55 |
| Re: Constraint question | Markus Schaber | 08:38 |
| usernames of a group from SQL | Kis János Tamás | 08:40 |
| Re: usernames of a group from SQL | Achilleus Mantzios | 10:04 |
| Problem with SET CONSTRAINTS ALL DEFERRED; | Kaloyan Iliev | 11:30 |
| Re: Problem with SET CONSTRAINTS ALL DEFERRED; | Stephan Szabo | 16:41 |
| Thread | Author | Time |
|---|---|---|
| Re: insert related data into two tables | Ash Grove | 00:54 |
| timestamp query doesn't use an index ... | Marc G. Fournier | 01:42 |
| Re: timestamp query doesn't use an index ... | Michael Glaesemann | 01:47 |
| Re: timestamp query doesn't use an index ... | Marc G. Fournier | 02:26 |
| Re: usernames of a group from SQL | kijato | 08:04 |
| Re: usernames of a group from SQL | Markus Schaber | 10:34 |
| Re: timestamp query doesn't use an index ... | Tom Lane | 15:31 |
| Re: timestamp query doesn't use an index ... | Marc G. Fournier | 17:08 |
| Re: timestamp query doesn't use an index ... | Tom Lane | 17:18 |
| Thread | Author | Time |
|---|---|---|
| Re: insert related data into two tables | Patrick JACQUOT | 09:31 |
| Does PG have a database | Mark Fenbers | 16:28 |
| Re: Does PG have a database | Markus Schaber | 17:52 |
| Re: Does PG have a database | Manlio Perillo | 17:59 |
| Question on UNION | mark.dingee | 18:58 |
| Re: Question on UNION | Markus Schaber | 19:07 |
| Thread | Author | Time |
|---|---|---|
| i need information regarding schema | Penchalaiah P. | 05:02 |
| Re: Does PG have a database | Achilleus Mantzios | 05:39 |
| Re: some error when executing query in pgAdmin tool | Dave Page | 12:06 |
| Re: some error when executing query in pgAdmin tool | Dave Page | 12:10 |
| some error when executing query in pgAdmin tool | Penchalaiah P. | 12:10 |
| Re: some error when executing query in pgAdmin tool | Patrick JACQUOT | 12:38 |
| hi can u give solution to this query | Penchalaiah P. | 12:40 |
| Re: hi can u give solution to this query | Dave Page | 12:43 |
| (Ab)Using schemas and inheritance | Jorge Godoy | 20:16 |
| Re: [SQL] (Ab)Using schemas and inheritance | Jim C. Nasby | 23:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Warehouse Schema | Richard Huxton | 09:54 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] (Ab)Using schemas and inheritance | Alban Hertroys | 09:25 |
| Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly | andi | 10:11 |
| hi how to use encryption for incomtax in postgresql | Penchalaiah P. | 10:31 |
| Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly | Andrew Sullivan | 10:50 |
| Re: hi how to use encryption for incomtax in postgresql | Andrew Sullivan | 10:52 |
| Re: hi how to use encryption for incomtax in postgresql | Richard Huxton | 12:30 |
| Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly | Bruno Wolff III | 14:08 |
| Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly | Andrew Sullivan | 14:22 |
| Re: [SQL] (Ab)Using schemas and inheritance | Merlin Moncure | 14:53 |
| Thread | Author | Time |
|---|---|---|
| Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly 📎 | Jesper K. Pedersen | 09:28 |
| Thread | Author | Time |
|---|---|---|
| Free 1000 Rupee bank note | AKHILESH GUPTA | 01:28 |
| Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly | andi | 02:52 |
| Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly | Alvaro Herrera | 04:18 |
| hi still i am unable to provide encryption to a particular table.... | Penchalaiah P. | 09:43 |
| Re: hi still i am unable to provide encryption to a particular table.... | Andrew Sullivan | 11:06 |
| Get max value from an comma separated string | Mauro Bertoli | 11:22 |
| distinct aggregate with complex type dont see the equality operator | Thomas Chille | 20:14 |
| Thread | Author | Time |
|---|---|---|
| hi i need to encrypt one field in a table | Penchalaiah P. | 10:12 |
| Re: hi i need to encrypt one field in a table | Juris | 10:14 |
| Re: hi i need to encrypt one field in a table | Mario Splivalo | 15:09 |
| Thread | Author | Time |
|---|---|---|
| datestyle on windows environment: how to set? | filippo | 17:53 |
| DELETE ... USING ... - 8.0 and 8.1 compatibility problem 📎 | Miroslav Šulc | 21:34 |
| Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem | Tom Lane | 21:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Advanced Query | Michael Fuhr | 00:00 |
| Re: Advanced Query | operationsengineer1 | 00:30 |
| Re: Table design question | David Clarke | 01:19 |
| Re: Am I crazy or is this SQL not possible | Aaron Bono | 01:44 |
| Re: Am I crazy or is this SQL not possible | Tom Lane | 02:41 |
| Re: Am I crazy or is this SQL not possible | Patrick Jacquot | 08:45 |
| Re: Am I crazy or is this SQL not possible 📎 | Klay Martens | 11:53 |
| Re: Am I crazy or is this SQL not possible | Aaron Bono | 15:23 |
| Re: Advanced Query | Michael Fuhr | 17:43 |
| Using Query Result in WHERE Clause | operationsengineer1 | 20:06 |
| Thread | Author | Time |
|---|---|---|
| Re: datestyle on windows environment: how to set? | Tom Lane | 02:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Get max value from an comma separated string | Bruno Wolff III | 02:12 |
| Re: Using Query Result in WHERE Clause | Andrew Sullivan | 11:10 |
| Re: Get max value from an comma separated string | Bricklen Anderson | 14:49 |
| Thread | Author | Time |
|---|---|---|
| How To Exclude True Values | operationsengineer1 | 00:17 |
| Re: How To Exclude True Values | operationsengineer1 | 02:07 |
| Re: How To Exclude True Values | operationsengineer1 | 02:24 |
| Re: How To Exclude True Values | Richard Broersma Jr | 02:36 |
| Re: Update Problem | Andrew Sullivan | 11:10 |
| Update Problem | Christian Paul Cosinas | 13:04 |
| Re: Advanced Query | codeWarrior | 14:48 |
| Re: Advanced Query | Richard Broersma Jr | 15:30 |
| Re: Advanced Query | Oisin Glynn | 15:41 |
| Re: Advanced Query | Scott Marlowe | 16:20 |
| Re: Advanced Query | codeWarrior | 16:20 |
| Re: Advanced Query | Andrew Sullivan | 16:30 |
| Re: Advanced Query | Andrew Sullivan | 16:32 |
| Re: Advanced Query | Aaron Bono | 16:37 |
| Re: How To Exclude True Values | operationsengineer1 | 17:07 |
| Re: How To Exclude True Values | Richard Broersma Jr | 17:36 |
| Join issue | Burak Seydioglu | 18:10 |
| Re: Join issue | Andrew Sullivan | 18:27 |
| Re: How To Exclude True Values | operationsengineer1 | 18:56 |
| How to get list of days between two dates? | Christine Desmuke | 21:06 |
| Re: How to get list of days between two dates? | Aaron Bono | 21:17 |
| Re: How to get list of days between two dates? | Scott Marlowe | 21:22 |
| Re: How To Exclude True Values | Richard Broersma Jr | 22:13 |
| Re: Join issue | operationsengineer1 | 22:33 |
| Re: How To Exclude True Values | operationsengineer1 | 23:01 |
| Re: How To Exclude True Values | Richard Broersma Jr | 23:40 |
| Re: Join issue | Kenneth B Hill | 23:53 |