pgsql-sql before 2018-04-17 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

Sept. 13, 2017

Thread Author Time
How could I improve a query with a function in the join clause? Daniel Franco 23:55

Sept. 14, 2017

Thread Author Time
Re: How could I improve a query with a function in the join clause? Andreas Kretschmer 01:40
Query is executing but giving error when using with shell scripting srilinux 15:58
Re: Query is executing but giving error when using with shell scripting Andreas Kretschmer 16:21
Re: Query is executing but giving error when using with shell scripting srilinux 16:27

Sept. 17, 2017

Thread Author Time
Odd sql error .. PropAAS DBA 03:01
Re: Odd sql error .. Steve Midgley 03:59

Sept. 20, 2017

Thread Author Time
SETOF any table records AS return in pgSQL functions athinivas 15:16
Re: SETOF any table records AS return in pgSQL functions David G. Johnston 16:20

Sept. 21, 2017

Thread Author Time
Single SQL to find if any record exists across several tables Ertan Küçükoğlu 12:45
Re: Single SQL to find if any record exists across several tables David G. Johnston 15:06

Sept. 22, 2017

Thread Author Time
Not able to find the postgres version in stack builder Vishwanath M.C 06:43

Sept. 27, 2017

Thread Author Time
Re: Single SQL to find if any record exists across several tables Feike Steenbergen 12:07

Sept. 29, 2017

Thread Author Time
Static variable inside PL/pgSQL (or) native C function athinivas 13:46
Re: Static variable inside PL/pgSQL (or) native C function Pavel Stehule 14:03
Re: Static variable inside PL/pgSQL (or) native C function David G. Johnston 14:04

Oct. 3, 2017

Thread Author Time
Re: Static variable inside PL/pgSQL (or) native C function athinivas 17:15
Re: Static variable inside PL/pgSQL (or) native C function Pavel Stehule 17:25

Oct. 5, 2017

Thread Author Time
Re: Re: Query is executing but giving error when using with shell scripting Feike Steenbergen 06:01
Get relation name form relids in postgresql Gourav Kumar 18:17

Oct. 6, 2017

Thread Author Time
Re: Get relation name form relids in postgresql Rene Romero Benavides 01:42
Re: Get relation name form relids in postgresql Gourav Kumar 02:48
Re: Get relation name form relids in postgresql Rene Romero Benavides 02:54
Re: Get relation name form relids in postgresql Gourav Kumar 02:55
Re: Get relation name form relids in postgresql Rene Romero Benavides 03:00
Re: Get relation name form relids in postgresql Gourav Kumar 03:04
Re: Get relation name form relids in postgresql Rene Romero Benavides 03:10

Oct. 9, 2017

Thread Author Time
Using Array in Function Günce Kaya 19:40
Re: Using Array in Function David G. Johnston 20:12
Re: Using Array in Function Günce Kaya 20:37

Oct. 10, 2017

Thread Author Time
Need Help on SQL Query ROS Didier 11:38
Re: Need Help on SQL Query hubert depesz lubaczewski 12:00
Re: Need Help on SQL Query ROS Didier 13:25
ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61 ROS Didier 13:28

Oct. 11, 2017

Thread Author Time
Re: ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61 Feike Steenbergen 06:20
Re: ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61 - fixed ROS Didier 07:49

Oct. 14, 2017

Thread Author Time
Only insert into tables trough functions Alvin Díaz 13:36

Oct. 16, 2017

Thread Author Time
How to index encrypted colums ? ROS Didier 13:38
Re: Only insert into tables trough functions Klaus Kaisersberger 15:31
Re: How to index encrypted colums ? Klaus Kaisersberger 15:47

Oct. 17, 2017

Thread Author Time
Re: How to index encrypted colums ? ROS Didier 07:49
Re: How to get the list of tables with encrypted columns ROS Didier 07:54
Re: How to index encrypted colums ? Steve Midgley 14:14
Re: How to index encrypted colums ? ROS Didier 15:17
Re: How to index encrypted colums ? Guillaume Lelarge 15:37