PostgreSQL - sql

This forum is an archive for the mailing list pgsql-sql@postgresql.org (more options) Messages posted here will be sent to this mailing list.
12345 ... 125
Topics (4374)
Replies Last Post Views
Ordering of arrays by Mike Martin-2
1
by Pavel Stehule
Ordering of arrays by Mike Martin
0
by Mike Martin
PLJAVA build failure on postgres docker image by Rick Vincent
1
by Rick Vincent
UPDATE command with FROM clause by JORGE MALDONADO
2
by David G Johnston
[ECPG] - Help on Dynamic Query using SQLDA with Cursors by Rajesh Parameswaran
0
by Rajesh Parameswaran
install sample database error by Cao, Xiaowei
3
by lup
Implicit typecast behavior by Rick Vincent
4
by Rick Vincent
Interesting security context issue by Erik Brandsberg
0
by Erik Brandsberg
Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? by Karen Goh
1
by David G Johnston
Re: pg_advisory_lock lock FAILURE / What does those numbers mean (process 240828 waits for ExclusiveLock on advisory lock [1167570,16820923,3422556162,1];)? by Laurenz Albe
0
by Laurenz Albe
Ordered Hierarchies. by Tim Uckun
7
by Tim Uckun
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? by Karen Goh
26
by Karen Goh
Error: rows returned by function are not all of the same row type by andrey.sychev
1
by Ed Behn
Would like to know what is the problem in my sql statement by Karen Goh
3
by Karen Goh
Alternate methods for multiple rows input/output to a function. by RAJIN RAJ K
0
by RAJIN RAJ K
Create function using quote_literal issues by Mohamed DIA
1
by Mohamed DIA
create index on a jsonb timestamp field? by Larry Rosenman
4
by Tom Lane-2
Table as argument in postgres function by RAJIN RAJ K
1
by Pavel Stehule
getting permission denied error for user2 while proper privileges are present by rajan
4
by rajan
Problem in by Max Lipsky
10
by David W Noon-3
XML with nodes by Leandro Carnio
0
by Leandro Carnio
create role/user management by Kirti Adesara
5
by David G Johnston
(no subject) by Mark Teper
5
by Sonnenberg-Carstens,...
ERROR: missing FROM-clause entry for table "new" by MICHAEL LAZLO III
3
by MICHAEL LAZLO III
Restrictions of channel arg of pg_notofy by Axel Rau
6
by Axel Rau
xpath insert unexpected newlines by Voillequin, Jean-Mar...
0
by Voillequin, Jean-Mar...
Partitioning table on tztsrange by Alexandre Lessard
0
by Alexandre Lessard
returning multiple refcursors from inner function by Debajyoti Saha
0
by Debajyoti Saha
Re: Archival process of partition tables with filtering few rows from tables. by Andreas Kretschmer-3
0
by Andreas Kretschmer-3
Re: Error while executing a view in postgres 10.5 by pavan95
1
by Jonathan S. Katz
Moving from TSQL to PL/pgsql select into a variable... by Ron Clarke
2
by Pavel Stehule
Jsonb column by MICHAEL LAZLO III
2
by MICHAEL LAZLO III
INSERT / UPDATE into 2 inner joined table simultaneously by Lou
5
by Tony Shelver
Why does GROUP BY reduce number of rows? by Rocky Ji
1
by Andrew Gierth
Top 3 values for each group in PGSQL by Ila B.
3
by Achilleas Mantzios
12345 ... 125