volatile;
Still there is an issue.
What if your point falls within multiple polygons (multiple records in
test1_poly satisfy your criteria)?
In this case, select from test1_poly should return multiple records. This
will break trigger function code.
Regards,
Igor Neyman
--
Sent via pgsql-sql
.user_id=T1.user_id);
Thanks,
Lance Campbell
Software Architect
Web Services at Public Affairs
217-333-0382
--
Try:
DELETE FROM t1
USING t2
WHERE t1.user_id != t2.user_id;
Test it before running on production db.
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing
whatever order you want inside aggregate function:
array_agg(outval order by column1)
Check the docs:
http://www.postgresql.org/docs/9.2/static/sql-expressions.html#SYNTAX-AGGREGATES
Igor Neyman
new List is created and there is no Items to assign to this
new List, yet. In this case, FK on Items table referencing List table makes
sure that every Item references existing (valid) List.
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes
Extension.
It also has other useful functions, such as crosstab.
Regards,
Igor Neyman
are perfect for hierarchical structures, and much cleaner
than 2-table design using ltree, that you show in the blog.
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
From: Don Parris [mailto:parri...@gmail.com]
Sent: Tuesday, February 26, 2013 1:23 PM
To: Misa Simic
Cc: Igor Neyman; pgsql-sql@postgresql.org
Subject: Re: [SQL] Using Ltree For Hierarchical Structures
Hi Igor,
As Misa points out, my original design used 2 tables - category line-items
;
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
to use ordinal column
positions in a query?
I am familiar with a few (in addition to Postgress), and none of them does
that, not in select list., though everybody allow ordinal position from
select list in order by and group by.
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql
-Original Message-
From: John Fabiani [mailto:jo...@jfcomputer.com]
Sent: Monday, June 11, 2012 11:11 AM
To: Igor Neyman
Cc: pgsql-sql@postgresql.org
Subject: Re: using ordinal_position
On 06/11/2012 06:53 AM, Igor Neyman wrote:
-Original Message-
From: John
segment from segments) as Y
Order by id, random();
Depending on the size of your tables, performance could become an issue.
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
reading on target RDBMS (in this case - PostgreSQL).
Otherwise, you will stumble on every step.
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
.nabble.com/Concurrent-Reindex-on-Primary-
Key-for-large-table-tp5467243p5470216.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
Did you try to make autovacuum more aggressive like lowering
autovacuum_vacuum_threshold from 2?
Regards,
Igor Neyman
--
Sent via pgsql-sql
the queries before and after a few other big queries to help
clear the cache).
adam
Adam,
Did you verify that your cache is cleared? Like using pg_buffercache
contrib. module?
Besides, there is also OS cache...
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org
or should run faster than union, at least because it does Bitmap
Heap Scan on dba_data_base only once, while union statement does this
heap scan 4 times (once per unionized select).
HTH,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription
('20110231', 'mmdd') from dual
*
ERROR at line 1:
ORA-01839: date not valid for month specified
SQL
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
statements in trigger executed before select from
outside if select is called somewhere between executing of
the trigger?
With MVCC writers don't block readers, and readers don't block writers.
Read PG docs on MVCC.
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org
rolname=$1))
and inx.indrelid in
(select oid from pg_class where relname=$2 and relowner in
(select oid from pg_authid where rolname=$1));
if v_count = 0 then
execute immediate 'create unique index $3 on $2 (acn_id)';
end if;
END;
$body$LANGUAGE PLPGSQL;
Regards,
Igor Neyman
--
Sent
rely upon are daily/hourly reports that are
run and formatted in sqlplus (break on report, compute sum, etc.). Is
there an equivalent available in postgres?
Thanks.
Tony
psql - not as advanced, doesn't have all the features SQL*Plus has.
Igor Neyman
Commands
Regards,
Igor Neyman
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
-Original Message-
From: Asko Oja [mailto:asc...@gmail.com]
Sent: Wednesday, September 15, 2010 2:29 PM
To: Igor Neyman
Cc: Tatarnikov Alexander; pgsql-sql@postgresql.org
Subject: Re: [SQL] Use CREATE USER in plpgsql function -
Found word(s) list error in the Text body
From: Asko Oja [mailto:asc...@gmail.com]
Sent: Wednesday, September 15, 2010 2:29 PM
To: Igor Neyman
Cc: Tatarnikov Alexander; pgsql-sql@postgresql.org
Subject: Re: [SQL] Use CREATE USER in plpgsql function - Found
word
delete trigger should return old.
In your code you return new for both: update and delete
Igor
-Original Message-
From: pgsql-sql-ow...@postgresql.org
[mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Ivan Sergio
Borgonovo
Sent: Friday, February 27, 2009 6:56 AM
To:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Emi Lu
Sent: Wednesday, September 17, 2008 2:55 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] prepared query plan did not update
Good morning,
I tried to use prepared query plan to update columns, but
select employee,count(distinct tasks),
greatest(max(last_job_date),max(last_position_date))
from job
group by employee
having greatest(max(last_job_date),max(last_position_date))
2008-08-28 + integer '1';
From: [EMAIL PROTECTED]
Maria,
Try (double quotes:
select x1 as IL-a, x2 as IL-a(p30) from abc
should help.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of maria s
Sent: Tuesday, July 29, 2008 12:07 PM
To: Osvaldo Rosario Kussama;
There are no synonyms in Postgres (like in Oracle).
To implement what you want, you need to use views and rules.
From Postgres docs:
Currently, views are read only: the system will not allow an insert,
update, or delete on a view. You can get the effect of an updatable view
by creating rules that
27 matches
Mail list logo