W dniu 11.05.2014 22:01, David G Johnston pisze:
On Sun, May 11, 2014 at 2:08 PM, Tim Kane [via PostgreSQL] <[hidden
email] >wrote:
[--]
This is basically what I intended to describe in "option 2"...without
the benefit of ever having really read the SQL standard.
So the p
Thenx for explanations.
W dniu 27.04.2014 16:56, David G Johnston pisze:
Andres Freund-3 wrote
Hi,
On 2014-04-27 10:23:18 +0200, Rafał Pietrak wrote:
I've just experienced an unexpected (for me) "loss" of DELETE. Is this a
feature or a bug (postgres v.s. SQL)?
I guess you&
Hi the list,
I've just experienced an unexpected (for me) "loss" of DELETE. Is this a
feature or a bug (postgres v.s. SQL)?
test case -
test=# CREATE TABLE test (a int, b text);
test=# INSERT INTO test (a,b) values (1,'asd');
test=# INSERT INTO
s like it does. I wouldn't thought, that the sort
order is maintaned from subquery, but if it does, this is just it.
It looks like I've just overdone the solution.
-R
On Friday, April 26, 2013, Rafał Pietrak wrote:
W dniu 04/26/2013 05:25 PM, Tom Lane pisze:
=?IS
W dniu 04/26/2013 05:25 PM, Tom Lane pisze:
=?ISO-8859-2?Q?Rafa=B3_Pietrak?= writes:
array_agg(distinct v order by v) -- works in postgres, but actually I need:
array_agg(distinct v order by v,x) -- which doesn't. (ERROR:
expressions must appear in argument list),
Why do you think you need
W dniu 04/26/2013 12:25 AM, Merlin Moncure pisze:
[--]
select array_agg(v order by v desc) from generate_series(1,3) v;
also, 'distinct'
select array_agg(distinct v order by v desc) from (select
generate_series(1,3) v union all select generate_series(1,3)) q;
[
W dniu 04/26/2013 12:25 AM, Merlin Moncure pisze:
On Thu, Apr 25, 2013 at 1:30 PM, Rafał Pietrak wrote:
[--]
No, I don't (manual:
http://www.postgresql.org/docs/9.1/static/tutorial-window.html, have just
one word "distinct" on that page, and it's not
W dniu 04/25/2013 03:44 PM, Merlin Moncure pisze:
On Wed, Apr 24, 2013 at 2:44 AM, Rafał Pietrak wrote:
W dniu 03/24/2013 12:11 PM, Rafał Pietrak pisze:
W dniu 03/24/2013 12:06 PM, Misa Simic pisze:
maybe,
SELECT DISTINCT issuer,amount, array_agg(REFERENCE) over (partition by
invoice_nr
W dniu 03/24/2013 12:11 PM, Rafał Pietrak pisze:
W dniu 03/24/2013 12:06 PM, Misa Simic pisze:
maybe,
SELECT DISTINCT issuer,amount, array_agg(REFERENCE) over (partition
by invoice_nr) from invoices;
RIGHT. Thenx. (and the first thing I did, I've read the doc on
array_agg() what s
The 0 result is not found and maybe, in your case, is faster the use of
internal text functions instead of like comparison... hope helps.
Bye
El 23/04/2013, a las 11:24, Rafał Pietrak escribió:
W dniu 04/22/2013 08:43 PM, Alfonso Afonso pisze:
I forgot to say that the function is "
W dniu 04/22/2013 08:43 PM, Alfonso Afonso pisze:
I forgot to say that the function is "position ( txtseach in
txtcomplete)" :)
Bye
Alfonso, thenx
But if I may: How can I use that function? In a context of my problem?
then again. At the edge of desperation, I'm thinking of writing a
funct
ide EXPLAIN ANALYSE of both cases If that would help, but that
will need some time, since the "two table" variant haven't finished in
5min, and I killed it before knowing how long it takes to complete.
-R
would be doing direct select instead of join select (in fact it is alm
... or not (I'm not quite sure)
Hello,
I have the following tables:
CREATE TABLE orders (info text, );
CREATE TABLE keywords (phrase text, .);
And I need to find all the ORDERS rows, which conain a PHRASE present in
the info column ... like so:
SELECT o.* from orders o join keywords k
-R
2013/3/24 Rafał Pietrak <mailto:ra...@zorro.isa-geek.com>>
Hi,
I really don't know how to ask for what I'm looking for; but I
think, may be, calling it an ARRAY yielding aggregate function for
use within a query WINDOW would do?
I'm looking fo
Hi,
I really don't know how to ask for what I'm looking for; but I think,
may be, calling it an ARRAY yielding aggregate function for use within a
query WINDOW would do?
I'm looking for something like:
SELECT DISTINCT issuer,amount, array(REFERENCE) over (partition by
invoice_nr) from invoi
W dniu 01/26/2013 02:49 PM, Alban Hertroys pisze:
On Jan 26, 2013, at 13:32, Rafał Pietrak wrote:
I have a usage recording table: CREATE TABLE readings(tm timestamp, bytesin
int, bytesout int);
The readouts are made "occasionally" - the timespan between the readouts are
not ve
Hello the list,
For some time now, I'm struggling with a problem of self join of a table:
I have a usage recording table: CREATE TABLE readings(tm timestamp,
bytesin int, bytesout int);
The readouts are made "occasionally" - the timespan between the readouts
are not very precise, but there i
W dniu 01/01/2013 07:24 PM, Adrian Klaver pisze:
On 01/01/2013 10:17 AM, Rafał Pietrak wrote:
[---]
If not, I think having OLD.* in INSERT rules/triggers is worth
pondering.
The thing is, that it would be a valuable tool to mimic table-propper
functionality by a view. The OLD
Hello the list,
As far as I can tell from a quick search through postgresql
documentation, the OLD.* pseudorelation is not available for INSERT
triggers and rules. And a little googleing I did, haven't pointed me to
anything relevant to the following. My apology if I miss in my search
such di
19 matches
Mail list logo
