| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi all,
We have issues on HP with the libpq.so client library when doing networking.
It appears that psql is linked with libxnet.so, but not...
Sebastien FLAESCH
|
02-18-2013 05:44 AM
Sebastien FLAESCH  | 0 | 17 |
| | | Hi,
I need to store data that has a valid timespan with start and enddate.
objects ( id, name, ... )
object_data ( object_id referencs objects(id),...
Andreas
|
02-17-2013 04:26 PM
Ben Morrow | 3 | 16 |
| | | Hello,
I have a rather complicated view that is dependent upon multiple
tables, consisting of several windowing and aggregate functions, as
well as...
Adam
|
02-17-2013 04:50 AM
Ben Morrow | 1 | 28 |
| | | Hello,
I hope someone her can help me.
We continuously load data from flat files in our database.
We first insert the data into unlogged tables (in...
Bert
|
02-17-2013 03:44 AM
Ben Morrow | 2 | 45 |
| | | Can I use a conditional expression in an UPDATE query like this:
UPDATE table_1 SET
field_1 =
CASE WHEN (condition) THEN (COALESCE(query_1,...
JORGE MALDONADO
|
02-07-2013 12:41 AM
Jasen Betts | 1 | 23 |
| | | I have an UPDATE query with the following general structure:
UPDATE table1 SET (SELECT field FROM table2 WHERE conditions ORDER BY
order_field LIMIT...
JORGE MALDONADO
|
02-06-2013 02:04 PM
JORGE MALDONADO | 4 | 17 |
| | | Greetings!
I need the following: create an index on multiple values for a single row. My other solution consists of a lot of duplicated rows in...
Francois Payette
|
02-06-2013 01:37 PM
Francois Payette | 1 | 13 |
| | | On 02/06/2013 08:09 AM, Dev Kumkar wrote:
Do NOT send questions to multiple lists. That is a waste of everybody's
time. So do NOT follow up this...
Andrew Dunstan
|
02-06-2013 07:42 AM
Andrew Dunstan | 0 | 9 |
| | | Dev Kumkar wrote:
You should specify a user=username option in the connection string,
otherwise that defaults to your operating system user...
Albe Laurenz
|
02-06-2013 07:30 AM
Albe Laurenz | 0 | 14 |
| | | Hello Everyone,
I am using postgres 9.2 and when executing function dblink facing a fatal
error while trying to execute dblink_connect as...
Dev Kumkar
|
02-06-2013 07:09 AM
Dev Kumkar | 0 | 12 |
| | | Hello everyone,
Please can you point me to the contrib/dblink package links.
What am actually looking for is query multiple database located...
Dev Kumkar
|
02-06-2013 05:01 AM
Dev Kumkar | 2 | 15 |
| | | I have a table with with an index that is of type 'timestamp without
time zone'. Multiple records are inserted per second so the index is...
Wayne Cuddy
|
02-05-2013 07:13 PM
Wayne Cuddy | 0 | 13 |
| | | Hello,
We are using postgres as a datawarehouse.
We typically use very complex queries, and they seem to work very well.
We have several BIG...
Bert
|
01-31-2013 10:48 AM
Jonathan S. Katz | 1 | 26 |
| | | Thank you Pavel,
I could do that like this:
select p.id,
( select array_accum ((
room_name, room_id, room_group_name, room_group_id,...
Nei Rauni Santos
|
01-31-2013 08:04 AM
Pavel Stehule | 1 | 14 |
| | | Hi Victor,
So, in conclusion, my misconception about CTE in general was that all CTE get called without being referenced.
Thank you much for the...
Kong Man
|
01-29-2013 08:45 PM
Kong Man | 2 | 26 |
| | | Hi
I've got functions that return a TABLE.
If I call it with constant parameters like:
SELECT * FROM some_fct( 42 );
I get a table with column...
Andreas
|
01-23-2013 07:42 PM
Tom Lane | 1 | 22 |
| | | Hi,
I have a little problem with extract epoch from interval. It seems that
the query works if the interval is in a string but not from DB...
Kaloyan Iliev
|
01-23-2013 08:37 AM
Adrian Klaver | 3 | 12 |
| | | Create a CTE with the project code and starting month of the project. Left join to month series CTE.
Sent from my smartphone
----- Reply message...
Alexander Gataric
|
01-23-2013 06:11 AM
Andreas | 1 | 9 |
| | | Hello everybody,
first a big thank you to all that make the range types possible. They are great, especially if one runs a database to manage a...
Matthias Nagel
|
01-23-2013 04:28 AM
Matthias Nagel | 0 | 7 |
| | | Hi
I need a series of month numbers like 201212, 201301 YYYYMM to join
other sources against it.
I've got a table that describes projects:
projects...
Andreas
|
01-22-2013 07:00 PM
Andreas | 4 | 8 |
| | | I would create a common table expression with the series from Filip and left join to the table you need to report on.
Sent from my smartphone
-----...
Alexander Gataric
|
01-22-2013 06:08 PM
Alexander Gataric | 0 | 8 |
| | | Hello!
I trade futures contracts and I have a PostgreSQL 9.2 database that keeps
track of all of my trading activity. The table includes columns...
M Lubratt
|
01-17-2013 05:30 PM
Venky Kandaswamy | 1 | 14 |
| | | Hi,
I'd like to know, per column, how many values were changed by my query.
I have a working example, but i am curious what you people think about...
Willy-Bas Loos
|
01-17-2013 12:30 PM
Akihiro Okuno | 1 | 9 |
| | | On 2013-01-16, James Sharrett <jsharrett (AT) tidemark (DOT) net> wrote:
look into "get diagnostics"
--
⚂⚃ 100% natural
--
Jasen Betts
|
01-17-2013 04:54 AM
Jasen Betts | 0 | 9 |
| | | On 01/16/2013 09:30 AM, James Sharrett wrote:
select count(*) from export_table into export_count();
raise notice 'Exported % rows',...
Rob Sargent
|
01-16-2013 11:46 AM
Misa Simic | 9 | 10 |
| | | I meant the count from the same query as for copy command what actually go
to file... Not count rows from table...
But i agree could be...
Misa Simic
|
01-16-2013 11:33 AM
Misa Simic | 0 | 8 |
| | | I have a function that generates a table of records and then a SQL statement
that does a COPY into a text file. I want to return the number of...
James Sharrett
|
01-16-2013 10:30 AM
James Sharrett | 0 | 8 |
| | | I have a PG function ( using plpgsql) that calls a number of sub functions
also in plpgsql. I have two main problems that seem to be variations on...
James Sharrett
|
01-15-2013 06:40 PM
Karl Grossner | 4 | 8 |
| | | Thanks for the quick and detailed response, Tom.
Yes, I did add a redundant where clause with a restriction on b.date_id on the range queries. This...
Venky Kandaswamy
|
01-15-2013 04:44 PM
Venky Kandaswamy | 0 | 7 |
| | | Venky Kandaswamy <venky (AT) adchemy (DOT) com> writes:
It's not very curious at all, or at least people on pgsql-performance
(the right list for...
Tom Lane
|
01-15-2013 04:30 PM
Tom Lane | 0 | 10 |
| | | All,
On 9.1, I am running into a curious issue. I will explain the issue in high level terms using psuedo SQL statements. Consider a SQL...
Venky Kandaswamy
|
01-15-2013 12:18 PM
Venky Kandaswamy | 0 | 6 |
| | | I am running a query like so
SELECT id FROM image WHERE image='demo-harvey wallbanger.jpg'
It returns nothing
My table looks like...
Barbara Woolums
|
01-15-2013 09:04 AM
Rob Sargent | 3 | 7 |
| | | Hello,
May I know how to generate drop table cascade when pg_dump a schema please?
E.g.,
pg_dump -h db_server -E UTF8 -n schema_name -U...
Emi Lu
|
01-09-2013 10:52 AM
Adrian Klaver | 1 | 8 |
| | | We have a database that was updated from 7.4.1 to 9.1.3. I've gotten
everything working, but now it seems that the users and groups weren't
restored....
Edward W. Rouse
|
01-08-2013 09:25 AM
Adrian Klaver | 1 | 7 |
| | | Hello,
Is there a function to split a string to different rows?
For example, t1(id, col1)
values(1, 'a, b, c');
select id,...
Emi Lu
|
01-08-2013 08:39 AM
Dave Page | 8 | 9 |
| | | I have a query similar to the one shown below but, depending on the value
of a field, only the first SELECT statement shoud execute and the other...
JORGE MALDONADO
|
12-29-2012 01:46 PM
Adrian Klaver | 3 | 8 |
| | | Hi, I also faced the same problem few days back. You can easily recove all
your photos from Android phone very easily. After a lot of search I found...
johnmethew
|
12-28-2012 05:11 PM
johnmethew | 0 | 7 |
| | | I have a record with the following fields:
id1, id2, id3, id4, price1, price2, price3, price4
I would like to write a SELECT statement in order to...
JORGE MALDONADO
|
12-28-2012 10:12 AM
Franz Timmer | 2 | 7 |
| | | Hi All,
I have this table:
LABEL ID Distance SIDE
"15"; 119006; 0.10975569030617; 1
"14"; ...
Antonio Parrotta
|
12-28-2012 09:30 AM
Andreas Kretschmer | 7 | 8 |
| | | Hi,
I have the following statement in a function.
UPDATE orderseq
SET orderseq_number = (orderseq_number + 1)
WHERE...
John Fabiani
|
12-27-2012 09:26 PM
msi77 | 4 | 6 |
| | | If a query returns, say the following results:
id value
0 a
0 b
0 c
1 a
1 b
Wes James
|
12-21-2012 12:50 PM
Wes James | 5 | 8 |
| | | Good morning,
Is there a simple way to load UTF8 data in psql to mysql(with latin1
encoding) through JDBC?
Thanks a lot!
Emi
--
Emi Lu
|
12-12-2012 01:34 PM
Adrian Klaver | 4 | 6 |
| | | Hello,
Anyone here with upsert experience?
I'm trying to run this query:
WITH UPSERT AS
(UPDATE oltp.ST_TRANSACTION
SET (row1,
row2,
Bert
|
12-04-2012 02:36 AM
Richard Huxton | 2 | 7 |
| | | Hi,
I use \copy to output tables into CSV files:
\copy (SELECT ...) TO 'a.csv' CSV
but for long and complex SELECT statements, it is cumbersome...
Seb
|
11-29-2012 09:35 AM
Sebastian P. Luque | 4 | 6 |
| | | I'm designing the schema to store a config from our switchboards.
As with all PBX's the key is the dialed number which is either an extension
number...
Gary Stainburn
|
11-29-2012 05:13 AM
Wolfe Whalen | 1 | 6 |
| | | I have a SELECT statement that gives me a result like this:
SONG ARTIST
-----------------------------------
Song1 Artist1
Song1 ...
JORGE MALDONADO
|
11-28-2012 12:52 PM
David Johnston | 3 | 7 |
| | | 2012/11/27 ssylla <stefansylla (AT) gmx (DOT) de>:
I'd said the sample is too simplified — not clear which id_product
should be picked if there're...
Виктор Егоров
|
11-27-2012 06:27 PM
Sergey Konoplev | 1 | 6 |
| | | Hi list,
I've got a locking problem which prevents me from doing some alters on my
tables. When I looked into pg_locks I saw a lot of entries...
Marcin Krawczyk
|
11-27-2012 03:27 AM
Marcin Krawczyk | 0 | 4 |
| | | Hi list,
I'm trying to use regexp_replace to get rid of all occurrences of
certain sub strings from my string.
What I'm doing is:
SELECT...
Marcin Krawczyk
|
11-20-2012 09:02 AM
Marcin Krawczyk | 2 | 6 |
| | | Hi,
I'm planning to centralize all db maintenance jobs from a single
pl/pgsql function called by cron every 15 minutes (highest frequency
required...
Louis-David Mitterrand
|
11-17-2012 06:50 PM
Jasen Betts | 5 | 6 |
