gmane.comp.db.postgresql.sql archive

426 archived articles, newest first (page 3 of 5). Latest articles →

Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Tue, 16 Jul 2019 10:57:25 +0200
Thomas Kellerer <[email protected]> • #32387
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Tue, 16 Jul 2019 09:54:44 +0100
Andrew Gierth <[email protected]> • #32386
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Tue, 16 Jul 2019 08:44:26 +0000 (UTC)
Karen Goh <[email protected]> • #32385
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Tue, 16 Jul 2019 09:41:05 +0100
Andrew Gierth <[email protected]> • #32384
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Tue, 16 Jul 2019 08:21:20 +0000 (UTC)
Karen Goh <[email protected]> • #32383
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Tue, 16 Jul 2019 08:25:17 +0200
Martin Stöcker <[email protected]> • #32382
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Tue, 16 Jul 2019 06:17:25 +0000 (UTC)
Karen Goh <[email protected]> • #32381
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Tue, 16 Jul 2019 06:14:35 +0000 (UTC)
Karen Goh <[email protected]> • #32380
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Sun, 14 Jul 2019 09:40:01 -0700
"David G. Johnston" <[email protected]> • #32379
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Sun, 14 Jul 2019 09:10:01 +0100
Andrew Gierth <[email protected]> • #32378
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Sun, 14 Jul 2019 03:39:58 +0000 (UTC)
Karen Goh <[email protected]> • #32377
Re: Error: rows returned by function are not all of the same row type
Fri, 12 Jul 2019 11:34:36 -0400
Ed Behn <[email protected]> • #32376
Re: Would like to know what is the problem in my sql statement
Fri, 12 Jul 2019 12:22:57 +0000 (UTC)
Karen Goh <[email protected]> • #32375
Would like to know what is the problem in my sql statement
Thu, 11 Jul 2019 19:34:24 -0700
"David G. Johnston" <[email protected]> • #32374
Re: Would like to know what is the problem in my sql statement
Thu, 11 Jul 2019 19:11:27 -0700
"Juan C. Olivares" <[email protected]> • #32373
Would like to know what is the problem in my sql statement
Fri, 12 Jul 2019 02:04:39 +0000 (UTC)
Karen Goh <[email protected]> • #32372
Error: rows returned by function are not all of the same row type
Thu, 4 Jul 2019 13:35:58 +0400
[email protected] • #32371
Re: Alternate methods for multiple rows input/output to a function.
Tue, 28 May 2019 07:59:30 -0700
Adrian Klaver <[email protected]> • #32370
Alternate methods for multiple rows input/output to a function.
Tue, 28 May 2019 20:06:16 +0530
RAJIN RAJ K <[email protected]> • #32369
Re: Create function using quote_literal issues
Thu, 23 May 2019 10:09:52 +0000
Mohamed DIA <[email protected]> • #32368
Create function using quote_literal issues
Thu, 23 May 2019 09:49:52 +0000
Mohamed DIA <[email protected]> • #32367
Re: create index on a jsonb timestamp field?
Sun, 19 May 2019 15:55:54 -0400
Tom Lane <[email protected]> • #32366
Re: create index on a jsonb timestamp field?
Sun, 19 May 2019 14:37:55 -0500
Larry Rosenman <[email protected]> • #32365
Re: Table as argument in postgres function
Sun, 19 May 2019 18:20:29 +0200
Pavel Stehule <[email protected]> • #32364
Table as argument in postgres function
Sun, 19 May 2019 21:30:23 +0530
RAJIN RAJ K <[email protected]> • #32363
Re: create index on a jsonb timestamp field?
Sat, 18 May 2019 21:17:35 -0400
Tom Lane <[email protected]> • #32362
Re: create index on a jsonb timestamp field?
Sat, 18 May 2019 19:19:34 -0500
Larry Rosenman <[email protected]> • #32361
create index on a jsonb timestamp field?
Sat, 18 May 2019 17:53:35 -0500
Larry Rosenman <[email protected]> • #32360
Re: getting permission denied error for user2 while proper privileges are present
Sat, 18 May 2019 09:35:50 -0700 (MST)
rajan <[email protected]> • #32359
Re: Unsubscribing from list (was: Problem in
Sat, 18 May 2019 17:27:09 +0100
David W Noon <[email protected]> • #32358
Unsubscribing from list (was: Problem in
Sat, 18 May 2019 16:33:13 +0100
David W Noon <[email protected]> • #32357
Re: getting permission denied error for user2 while proper privileges are present
Sat, 18 May 2019 11:07:05 -0400
Tom Lane <[email protected]> • #32356
Re: getting permission denied error for user2 while proper privileges are present
Fri, 17 May 2019 22:50:26 -0700 (MST)
rajan <[email protected]> • #32355
Re: getting permission denied error for user2 while proper privileges are present
Sat, 18 May 2019 00:46:57 -0400
Tom Lane <[email protected]> • #32354
getting permission denied error for user2 while proper privileges are present
Fri, 17 May 2019 21:13:16 -0700 (MST)
rajan <[email protected]> • #32353
Re: Problem in
Fri, 17 May 2019 22:31:33 -0500
Charles Sheridan <[email protected]> • #32352
Re: Problem in
Sat, 18 May 2019 11:13:31 +0800
Javin Paul <[email protected]> • #32351
Re: Problem in
Fri, 17 May 2019 12:09:44 -0400
Jean-David Beyer <[email protected]> • #32350
XML with nodes
Thu, 16 May 2019 08:50:47 -0300
Leandro Carnio <[email protected]> • #32349
Re: create role/user management
Mon, 6 May 2019 13:08:19 -0700
"David G. Johnston" <[email protected]> • #32348
Re: create role/user management
Mon, 6 May 2019 12:51:50 -0700
Steve Midgley <[email protected]> • #32347
Re: create role/user management
Mon, 6 May 2019 13:49:15 -0600
Rob Sargent <[email protected]> • #32346
Re: create role/user management
Mon, 6 May 2019 12:43:40 -0700
"David G. Johnston" <[email protected]> • #32345
Re: create role/user management
Mon, 6 May 2019 12:35:37 -0700
Steve Midgley <[email protected]> • #32344
AW: plpython transforms vs. arrays
Mon, 6 May 2019 09:34:08 +0000
"Sonnenberg-Carstens, Stefan" <[email protected]> • #32343
Re: plpython transforms vs. arrays
Mon, 6 May 2019 05:32:40 -0400
Mark Teper <[email protected]> • #32342
AW:
Mon, 6 May 2019 08:17:46 +0000
"Sonnenberg-Carstens, Stefan" <[email protected]> • #32341
create role/user management
Sat, 4 May 2019 16:38:07 +0000
Kirti Adesara <[email protected]> • #32340
Re: plpython transforms vs. arrays
Fri, 3 May 2019 06:53:43 +0200
Jiří Fejfar <[email protected]> • #32339
Re: plpython transforms vs. arrays
Thu, 02 May 2019 22:56:14 -0400
Tom Lane <[email protected]> • #32338
(unknown)
Thu, 2 May 2019 13:51:22 -0400
Mark Teper <[email protected]> • #32337
Re: ERROR: missing FROM-clause entry for table "new"
Tue, 30 Apr 2019 11:27:49 -0400 (EDT)
Mike LAZLO <[email protected]> • #32336
RE: ERROR: missing FROM-clause entry for table "new"
Tue, 30 Apr 2019 13:53:44 +0000
"Voillequin, Jean-Marc" <[email protected]> • #32335
Re: ERROR: missing FROM-clause entry for table "new"
Tue, 30 Apr 2019 09:47:38 -0400
Tom Lane <[email protected]> • #32334
ERROR: missing FROM-clause entry for table "new"
Tue, 30 Apr 2019 09:41:32 -0400 (EDT)
Mike LAZLO <[email protected]> • #32333
[RESOLVED] Re: Restrictions of channel arg of pg_notofy
Mon, 29 Apr 2019 10:23:50 +0200
Axel Rau <[email protected]> • #32332
Re: Restrictions of channel arg of pg_notofy
Sun, 28 Apr 2019 14:23:16 -0400
Tom Lane <[email protected]> • #32331
Re: Restrictions of channel arg of pg_notofy
Sun, 28 Apr 2019 19:46:12 +0200
Axel Rau <[email protected]> • #32330
Re: Restrictions of channel arg of pg_notofy
Sun, 28 Apr 2019 13:02:06 -0400
Tom Lane <[email protected]> • #32329
Re: Restrictions of channel arg of pg_notofy
Sun, 28 Apr 2019 18:22:12 +0200
Axel Rau <[email protected]> • #32328
Re: Restrictions of channel arg of pg_notofy
Sat, 27 Apr 2019 14:51:57 -0400
Tom Lane <[email protected]> • #32327
Restrictions of channel arg of pg_notofy
Sat, 27 Apr 2019 19:51:46 +0200
Axel Rau <[email protected]> • #32326
Re: Problem in
Sat, 27 Apr 2019 10:32:37 +0300
Max Lipsky <[email protected]> • #32325
Re: Problem in
Sat, 27 Apr 2019 12:34:31 +1200
Andrej <[email protected]> • #32324
Re: Problem in
Fri, 26 Apr 2019 00:08:27 +0300
Max Lipsky <[email protected]> • #32323
Re: Problem in
Thu, 25 Apr 2019 17:41:39 -0400
Tom Lane <[email protected]> • #32322
Re: Problem in
Thu, 25 Apr 2019 12:56:46 -0400
Tom Lane <[email protected]> • #32321
Problem in
Thu, 25 Apr 2019 16:45:18 +0300
Max Lipsky <[email protected]> • #32320
xpath insert unexpected newlines
Fri, 19 Apr 2019 13:04:37 +0000
"Voillequin, Jean-Marc" <[email protected]> • #32319
Partitioning table on tztsrange
Thu, 11 Apr 2019 10:05:13 -0400
Alexandre Lessard <[email protected]> • #32318
returning multiple refcursors from inner function
Fri, 29 Mar 2019 08:11:17 +0000
Debajyoti Saha <[email protected]> • #32317
Re: Archival process of partition tables with filtering few rows from tables.
Fri, 29 Mar 2019 06:42:52 +0100
Andreas Kretschmer <[email protected]> • #32316
Archival process of partition tables with filtering few rows from tables.
Thu, 28 Mar 2019 23:13:31 -0500
github kran <[email protected]> • #32315
Re: Error while executing a view in postgres 10.5
Fri, 22 Mar 2019 09:08:38 -0400
"Jonathan S. Katz" <[email protected]> • #32314
Re: Error while executing a view in postgres 10.5
Fri, 22 Mar 2019 04:26:04 -0700 (MST)
pavan95 <[email protected]> • #32313
Re: Moving from TSQL to PL/pgsql select into a variable...
Mon, 18 Mar 2019 16:06:19 +0100
Pavel Stehule <[email protected]> • #32312
Re: Moving from TSQL to PL/pgsql select into a variable...
Mon, 18 Mar 2019 07:57:46 -0700
"David G. Johnston" <[email protected]> • #32311
Moving from TSQL to PL/pgsql select into a variable...
Mon, 18 Mar 2019 14:52:56 +0000
Ron Clarke <[email protected]> • #32310
Re: Jsonb column
Tue, 12 Mar 2019 12:30:16 -0400 (EDT)
MICHAEL LAZLO <[email protected]> • #32309
Re: Jsonb column
Tue, 12 Mar 2019 16:27:22 +0200
Alexandru Lazarev <[email protected]> • #32308
Jsonb column
Tue, 12 Mar 2019 09:33:31 -0400 (EDT)
MICHAEL LAZLO <[email protected]> • #32307
Re: INSERT / UPDATE into 2 inner joined table simultaneously
Thu, 7 Mar 2019 07:44:49 +0200
Tony Shelver <[email protected]> • #32306
Re: INSERT / UPDATE into 2 inner joined table simultaneously
Wed, 6 Mar 2019 14:45:41 -0800
Steve Midgley <[email protected]> • #32305
Re: INSERT / UPDATE into 2 inner joined table simultaneously
Wed, 6 Mar 2019 12:41:13 -0900
Christopher Swingley <[email protected]> • #32304
Re: INSERT / UPDATE into 2 inner joined table simultaneously
Wed, 6 Mar 2019 11:11:23 -0900
Christopher Swingley <[email protected]> • #32303
Re: INSERT / UPDATE into 2 inner joined table simultaneously
Wed, 6 Mar 2019 15:36:21 -0600
Lou <[email protected]> • #32302
INSERT / UPDATE into 2 inner joined table simultaneously
Wed, 6 Mar 2019 13:59:22 -0600
Lou <[email protected]> • #32301
Re: Why does GROUP BY reduce number of rows?
Fri, 01 Mar 2019 13:25:53 +0000
Andrew Gierth <[email protected]> • #32300
Re: Top 3 values for each group in PGSQL
Fri, 1 Mar 2019 15:17:48 +0200
Achilleas Mantzios <[email protected]> • #32299
Why does GROUP BY reduce number of rows?
Fri, 1 Mar 2019 18:25:44 +0530
Rocky Ji <[email protected]> • #32298
Re: Top 3 values for each group in PGSQL
Fri, 1 Mar 2019 13:52:02 +0100
Thomas Kellerer <[email protected]> • #32297
Re: Top 3 values for each group in PGSQL
Fri, 1 Mar 2019 12:59:11 +0100
hubert depesz lubaczewski <[email protected]> • #32296
Top 3 values for each group in PGSQL
Fri, 1 Mar 2019 11:51:24 +0100
"Ila B." <[email protected]> • #32295
Re: PostgreSQL DB Maintenance and Partitioning to keep data longer.
Tue, 26 Feb 2019 23:51:58 -0600
github kran <[email protected]> • #32294
Re: Database link
Fri, 22 Feb 2019 18:21:39 -0500
MichaelDBA <[email protected]> • #32293
Database link
Fri, 22 Feb 2019 21:16:40 +0100 (CET)
MICHAEL LAZLO III <[email protected]> • #32292
Re: Group By aggregate string function
Thu, 21 Feb 2019 21:06:15 +0100
Martin Stöcker <[email protected]> • #32291
Re: Group By aggregate string function
Thu, 21 Feb 2019 12:53:59 -0700
"David G. Johnston" <[email protected]> • #32290
Re: Group By aggregate string function
Thu, 21 Feb 2019 19:02:27 +0000
"Campbell, Lance" <[email protected]> • #32289
Group By aggregate string function
Thu, 21 Feb 2019 18:59:18 +0000
"Campbell, Lance" <[email protected]> • #32288
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.