e BEGIN - there is no period there, because I don't
> have and endpoint. Similarly, user_id 1 has BEGIN as the last action -
> just two periods for user_id 1, because last BEGIN denotes 'period in
> progress'.
>
> Also, user_id 1 has following actions happened, time o
ER;
CREATE FUNCTION
dynacom=#
dynacom=#
>
> regards, tom lane
>
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--+-
1 | 5 day eastern carribean cruise | {1,5}
2 | 5 day western carribean cruise | {2,6}
3 | 5 day eastern carribean cruise | {3,7}
4 | 5 day western carribean cruise | {4,8}
(4 rows)
EXERCISE:
Why cant we excl
lly I'd like to know if this should be a single table or should
> there be a separate table for each level of the hierarchy (four in all)? If
> one table, should the digits be broken into separate columns? Should parent
> ids be stored in each node?
>
> More generally, what quest
Στις Wednesday 07 April 2010 10:53:00 ο/η silly sad έγραψε:
> On 04/07/10 11:00, Achilleas Mantzios wrote:
>
> > Column | Type| Modifiers
> > -+---+--
nkedin.com/in/grayhemp /
> JID/GTalk: gray...@gmail.com / Skype: gray-hemp / ICQ: 29353802
>
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Στις Wednesday 07 April 2010 11:06:44 ο/η Yeb Havinga έγραψε:
> Achilleas Mantzios wrote:
> > You could also consider the genealogical approach, e.g.
> >
> >
> > The parents of any node to the root, i.e. the path of any node to the root
> > are depicted as
Στις Wednesday 07 April 2010 23:33:07 ο/η Yeb Havinga έγραψε:
> Achilleas Mantzios wrote:
> > Στις Wednesday 07 April 2010 11:06:44 ο/η Yeb Havinga έγραψε:
> >
> >> Achilleas Mantzios wrote:
> >>
> >>> You could also consider the genealogical ap
Στις Thursday 08 April 2010 17:59:01 ο/η Rob Sargent έγραψε:
> The "parent" node in a genealogy is the mother-father tuple, so given
> that as a singularity it still fits a tree.
No, because the child and parent node would be of different schema.
>
> On 04/08/2010 12:56
s,
even easier and more robustly
than it is the case now.
Lets hope those guys will deliver smth good.
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Στις Wednesday 21 July 2010 10:57:45 ο/η Dave Page έγραψε:
> On Wed, Jul 21, 2010 at 7:47 AM, Achilleas Mantzios
> wrote:
> > It seems there are certain projects running at the moment that will
> > eventually make possible
> > to run PostgreSQL on FreeBSD's jail
Στις Wednesday 17 November 2010 15:22:34 ο/η Ferruccio Zamuner έγραψε:
>
> /* How to get access to its items then?
> */
select (mesh_split('A01.378.610.250.300.792.380')::text[])[1];
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
8.n5.nabble.com/Deleting-entries-from-multiple-tables-tp3285654p3285654.html
> > Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
> >
> > --
> > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> > To make changes to your subscription:
> &g
'fuel':20 'hour':27
'inspect':57 'job':9,30 'kind':43 'main':1,16 'master/cheng':4 'note':6
'opportun':54 'overlook':41 'pleas':5 'pms':62 'pump':21 'report':55
'request':44 'respect':49 'result':58 'shock':22,50 'sinc':28 'tech.dept':64
'tks/brgds':63 'vessel':14,38 'vma':61 'vma-pm':60
(1 row)
and (the important command in 8.4.6)
dynacom=# SELECT idxfti @@ to_tsquery('overlooked') from vmanews where id=28717;
?column?
--
f
(1 row)
So, searching for "overlooked" which the original word in the text, in 8.3
idxfti @@ to_tsquery('overlooked') returns true
while in 8.4.6 idxfti @@ to_tsquery('overlooked') returns false.
Is there anything i am missing?
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
oo from psql
>
> Regards
>
> Pavel Stehule
>
> > Thanx in advance
> > --
> > ---
> > Viktor Bojović
> > ---
> > Wherever I go, Murphy goes with me
> >
>
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
SQL
standard requires.
http://www.postgresql.org/docs/8.3/interactive/sql-select.html
"The AS Key Word
In the SQL standard, the optional key word AS is just noise and can be omitted
without affecting the meaning.
The PostgreSQL parser requires this key word when renaming output columns
8.n5.nabble.com/Retrieve-the-column-values-of-a-record-without-knowing-the-names-tp3387935p3387935.html
> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Hello,
just a question regarding multidimensional arrays.
When i create an array, its number of dimensions is recorded in
pg_catalog.pg_attribute (attndims), but they are not enforced upon insertion,
nor is this presented by \d command. (i didn't see any attndims column showing
up in the logs)
On Παρ 03 Φεβ 2012 22:21:49 Dmitriy Igrishin wrote:
> Hey Achilleas,
>
> 2012/2/3 Achilleas Mantzios
>
> > Hello,
> > just a question regarding multidimensional arrays.
> > When i create an array, its number of dimensions is recorded in
> > pg_catalog.pg_at
d | bigint | not null
Indexes:
"it_tmp_pk" PRIMARY KEY, btree (id, xid)
Foreign-key constraints:
"items_tmp_xid_fkey" FOREIGN KEY (xid) REFERENCES xadmin(xid)
-
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
On Παρ 15 Ιουν 2012 09:34:16 Richard Huxton wrote:
> On 14/06/12 09:39, Achilleas Mantzios wrote:
> > dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=61972;
> >
> > id
> >
> > -
> >
> > 1261319
> >
> > (1 row)
On Παρ 15 Ιουν 2012 10:28:20 Scott Marlowe wrote:
> You do realize you're missing four years of bug fixes right?
On Πεμ 14 Ιουν 2012 11:39:35 Achilleas Mantzios wrote:
> Unfortunately the remote installations are neither physically accessible
> nor by TCP/IP accesible (comms are don
On Παρ 15 Ιουν 2012 12:28:21 Samuel Gendler wrote:
> On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios <
>
> ach...@matrix.gatewaynet.com> wrote:
> > And i forgot to mention, minicom term emulation quality sucks, even
> > giving simple
> > shell commands is
On Παρ 15 Ιουν 2012 12:29:38 Samuel Gendler wrote:
> On Fri, Jun 15, 2012 at 2:28 AM, Samuel Gendler
>
> wrote:
> > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios <
> >
> > ach...@matrix.gatewaynet.com> wrote:
> >> And i forgot to mention,
ave TCP/IP connectivity to (most of) the ships,
and AFAIK apt-get does not yet work
over advanced UUCP/minicom/kermit or other equivalent hich-tech dial up
connection.
just joking :)
>
> On Fri, Jun 15, 2012 at 2:24 AM, Achilleas Mantzios
>
> wrote:
> > On Παρ 15 Ιουν 2012
> sudo apt-get upgrade
> >>
> >> or similar and sit back and watch.
> >
> > Thanx, unfortunately we dont have TCP/IP connectivity to (most of) the
> > ships, and AFAIK apt-get does not yet work over advanced
> > UUCP/minicom/kermit or other equivalen
On Σαβ 16 Ιουν 2012 03:22:16 you wrote:
> On Fri, Jun 15, 2012 at 3:06 AM, Achilleas Mantzios <
>
> ach...@matrix.gatewaynet.com> wrote:
> > On Παρ 15 Ιουν 2012 12:29:38 Samuel Gendler wrote:
> > > On Fri, Jun 15, 2012 at 2:28 AM, Samuel Gendler
> > >
>
.
> >
> > On Fri, Jun 15, 2012 at 9:32 AM, Achilleas Mantzios
> >
> > wrote:
> > > On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote:
> > >> Not talking about going to something after 8.3.19, just updating to
> > >> the latest 8.3 version.
On Τετ 20 Ιουν 2012 07:08:09 Craig Ringer wrote:
> On 06/19/2012 05:17 PM, Achilleas Mantzios wrote:
> > We had another corruption incident on the very same machine, this time in
> > the jboss subsystem (a "jar cvf" produced corrupted .jar). IMHO this
> > means fault
'.
I use the query below
SELECT id FROM table WHERE name LIKE '% foo %';
Sometimes the query return with nTuples=0 but there are matching rows.
On retry, the query return with expected results. Any ideas;
(postgres ver 9.2, libpq - C Library)
-
Achilleas Mantzios
IT DEPT
setid does not exist
LINE 1: ...gth(qry.arragg,1)>1 AND qry.setid NOT IN (SELECT soc.setid ...
^
dynacom=#
postgresql corerctly identifies and throws the error.
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent vi
Thanx Tom.
On Πεμ 14 ÎÎ±Ï 2013 12:17:46 Tom Lane wrote:
> Achilleas Mantzios writes:
> > dynacom=# SELECT DISTINCT ON (qry.setid) qry.setid, qry.arragg[1:2] FROM
> > (select distinct sst.setid,(array_agg(vsl.name) OVER (PARTITION BY
> > sst.setid ORDER BY char
arrant data integrity under all
> circumstances. Such as concurrent update, insert, delete etc.
>
I think your best bet is a trigger.
use RAISE EXCEPTION to indicate an erroneous situation so as to
make the transaction abort. (there is nothing wrong in getting your hands
dirty with pl/pgsql
ing
without
getting under the hood.
> >;->
>
> After all, this should be really an ultra-classic-standard FAQ item.
>
> I'm definitely not the first database user in the world who needs to
> have a 1:n relationship with n>0 and integrity enforced by the
> data
ing
without
getting under the hood.
> >;->
>
> After all, this should be really an ultra-classic-standard FAQ item.
>
> I'm definitely not the first database user in the world who needs to
> have a 1:n relationship with n>0 and integrity enforced by the
> d
.
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
ential or exempt from disclosure
> under applicable law. If you are not the intended recipient or it appears
> that this mail has been forwarded to you without proper authority, you are
> notified that any use or dissemination of this information in any manner is
> strictly prohibited. In such cases, please notify us immediately at
> [EMAIL PROTECTED] and delete this email from your records.
--
Achilleas Mantzios
---(end of broadcast)---
TIP 6: explain analyze is your friend
27; thing. It's just a matter of aesthetic preference.
Alright, you could play with something like:
UPDATE pg_attribute SET attnum = where
attrelid= and attname='';
but do some research of possible bad side effects.
--
Achilleas Mantzios
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Στις Πέμπτη 05 Οκτώβριος 2006 16:31, ο/η Tom Lane έγραψε:
> Achilleas Mantzios <[EMAIL PROTECTED]> writes:
> > Alright, you could play with something like:
> >
> > UPDATE pg_attribute SET attnum = where
> > attrelid= and attname='';
>
> That'
is number to your "range" like this:
let your number be r.
let your table's cardinality be N.
then let R=(N*r/(2^31))+1
select a source row from your table like:
select * from srctable order by pk offset ,
and then insert this row to your desttable.
>
>
> Andreas
From: Achilleas Mantzios <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Στις Τρίτη 17 Οκτώβριος 2006 11:34, ο/η Andreas Kretschmer έγραψε:
> Felix Zhang <[EMAIL PROTECTED]> schrieb:
> > Hi,
> >
> > I want to split a table to 2 small tables. The 1st one contains 6
--(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
>match
--
Achilleas Mantzios
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> Thanks,
> Luca
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
--
Achilleas Mantzios
---(end of broadcast)---
TIP 9: In ver
ll take forever.
> the larger database etc ?
>
>
> Regards...
--
Achilleas Mantzios
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ique Iazzetti Santos
> Compels Inform�tica
> Santa Rita do Sapuca� - MG
> www.compels.net
>
>
>
>
>
>
> ___
> O Yahoo! est� de cara nova. Venha conferir!
> http://br.yahoo.com
--
Achilleas Mantzios
---(end of broadcast)---
TIP 1: i
7;21.01.2007'::date); time_intersect
> ---
> ("13.01.2007 00:00:00 CET","20.01.2007 00:00:00 CET")
> (1 row)
>
>
> test=*# select *, t2-t1 from time_intersect('10.01.2007'::date,
> '20.01.
l violate the unique primary key constraint:
>
> insert into xx_plan_rule select * from xx_plan_rule where rule_id=9;
> ERROR: duplicate key violates unique constraint "xx_plan_rule_pkey"
If you have that requirement often i would recommend writing
a program taking the tablename
M sal_emp WHERE name = 'Bill';
you would still get {{meeting,lunch}} as a result.
(Right or wrong is another story).
Anyway the first time you query for a "text",
the second time you query for a "text[]", so you should expect
different results.
--
Achilleas Mantzios
-
the other case it means "1:2") and the context is
> determined by the format of indexes on other dimensions.
>
> I believe I understandbut incredibly confusing.
>
Now that i think about it again, i speculate that the [2] is discarded.
> - chris
>
> Achilleas Mantz
ng,presentation}}' as text[][]))[1:1][1000];
text
---
{{meeting,lunch}}
(1 row)
dynacom=#
>
> Achilleas Mantzios wrote:
> > Στις Πέμπτη 15 Φεβρουάριος 2007 18:55, ο/η chrisj έγραψε:
> >> Thanks Achilleas,
> >>
> &g
so that your
> message can get through to the mailing list cleanly
--
Achilleas Mantzios
---(end of broadcast)---
TIP 6: explain analyze is your friend
a little bit.
--
Achilleas Mantzios
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
roadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
--
Achilleas Mantzios
-
you think that criticizing was better than staying silent?
Anyway, Joshua already took some very enlightening answers enuf to get him
going.
--
Achilleas Mantzios
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
g t2 where t2.click and t2.cid=tglob.cid) as
countclicks from tracking tglob;
?
> Mike
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
--
Achilleas Mantzios
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
e same
> status...
It should also be UNION ALL, just in case some status'es are common in the 2
subqueries.
>
> ---(end of broadcast)---
> TIP 7: You can help support the PostgreSQL project by donating at
>
>
n
> _
> In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten!
> Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114
>
>
> ---(end of
ow();
from within psql, output in your system?
>
> TIA,
> Sabin
>
>
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your
If you do
SELECT "colVarchar","colVarcharArray"[1] FROM test;
you will see that you get identical values.
--
Achilleas Mantzios
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
hes.
>
> Sabin
I would recommend:
a) Move to Unix
b) Subscribe to [EMAIL PROTECTED]
>
>
>
> ---(end of broadcast)-------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.
I noticed that in pl/pgsql simply
result := funcname(func,args,...);
just works.
Should i rely on it or take it as a coincidence? :)
--
Achilleas Mantzios
---(end of broadcast)---
TIP 6: explain analyze is your friend
Στις Tuesday 04 December 2007 14:59:43 ο/η Pavel Stehule έγραψε:
> On 04/12/2007, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> > I noticed that in pl/pgsql simply
> > result := funcname(func,args,...);
> > just works.
> > Should i rely on it or take it a
mp set num = 1 + num/1000 where num >= 6;
--
Achilleas Mantzios
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
i had to add PG_DETOAST_DATUM on any array Datum.
The code seems to work however i'd like your comments if i miss something.
Thanks a lot.
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
valid) in the where clause above?
>
> Do you use oid? We had an issue where old code relied on oid and when
> we tested 8.2 we had issues with oid being used but not available. The
> fix was easy and only required a id-column of type serial.
>
No, we dont use OID as primary keys.
there anything reliable to achieve this without making poor assumptions of
the future
versions, or should i just "SELECT ... ORDER BY ..." and then perform
individual UPDATEs?
Thanx
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make chang
Στις Tuesday 02 September 2008 17:24:05 ο/η Richard Broersma έγραψε:
> On Tue, Sep 2, 2008 at 2:58 AM, Achilleas Mantzios
> <[EMAIL PROTECTED]> wrote:
> > is there an (implicit) way to make a multirow update execute on some rows
> > prior to other rows?
> > It is ne
Στις Wednesday 03 September 2008 15:28:04 ο/η Richard Broersma έγραψε:
> On Tue, Sep 2, 2008 at 11:56 PM, Achilleas Mantzios
> <[EMAIL PROTECTED]> wrote:
> > I am using my version of DB mirror to do some kind of "Conditional row
> > grained + FK dependency oriente
t; ) AS raw_total
> >
> Pavel, Richard, you got it dudes! I have to say, that kinda 'reference
> before assingment' of "total" doesnt look logical to me.
>
Then, both you and your boss need some SQL courses :) (no offense)
> Thanks again!!
> Gerardo
LECT p FROM idx)])[i][j];
1<=i<=2
1<=j<=select count(*) from idx
>
> regards
> mk
>
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
t?
Is there any thoughts/needs/discussions of changing this behaviour in a future
version
thus breaking my program?
Thanx a lot
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Στις Tuesday 27 January 2009 14:40:29 ο/η Raj Mathur έγραψε:
> select regexp_split_to_array('string with tokens', '[^A-Za-z0-9]');
>
maybe
select regexp_split_to_table('string with tokens', '[^A-Za-z0-9]');
would help?
--
Achilleas Mantzios
r what could possibly alter
> table be doing all this time.
Which version of postgresql do you use?
Also you might consider editing the SQL dump to alter
the DDL statements prior to loading it in your db.
batch editing sed, awk, perl, could help you on that...
>
> Regards, Zdravko.
&
Στις Monday 23 March 2009 09:59:12 ο/η Zdravko Balorda έγραψε:
>
> Hi,
> I need a casting operator from boolean to integer,
> tu put in ALTER TABLE statment after USING.
>
How about
CASE WHEN 't' THEN 1 ELSE 0 END
> Any ideas? Thanks.
>
> Zdravko
>
>
T 't'::boolean::int;
int4
--
1
(1 row)
and
SELECT 'f'::boolean::int;
int4
--
0
(1 row)
work in 8.3
> Any ideas? Thanks.
>
> Zdravko
>
>
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make chan
you able
to start psql and do some simple command?
Have you ruled out the possibility of the application being locked for other
reasons? (limits, network failure,etc)
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
then you would do that with: intset(parid) ~ parents
For the above to be efficient you should create an index on parents. Prefer
method "gin" with opclass "gin__int_ops"
Well thats how i implemented trees in postgresql anyway.
>
> In other words, testing against the fi
77 matches
Mail list logo
