ion in thi case?
Any help appriciated. Thanks.
Best regards,
Anton Nikiforov
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Andreas Kretschmer wrote:
begin "Raymond O'Donnell" <[EMAIL PROTECTED]> wrote:
Happy Christmas from the west of Ireland! - Nollaig shona dÃobh.
Happy Christmass and New Year from Russia
--
Ð Ñ (Best regads),
ÐÐÑÐÐ ÑÐÑÐÐ (Anton Nikiforov)
smime.p7s
Description:
Dear All.
is there any function that can translate INT to INET type?
the table contains ip and mask in different fields (int fields):
ip | integer | default 0
mask| integer | default -1
db=> select ip, mask from ips limit 2;
ip | mask
Tom Lane wrote:
Anton Nikiforov <[EMAIL PROTECTED]> writes:
is there any function that can translate INT to INET type?
Nothing built-in, and given the fact that "inet" no longer means "IPv4",
it's unlikely we'd add one in the future. But there's not
Tom Lane wrote:
Anton Nikiforov <[EMAIL PROTECTED]> writes:
is there any function that can translate INT to INET type?
Nothing built-in, and given the fact that "inet" no longer means "IPv4",
it's unlikely we'd add one in the future. But there'
Martijn van Oosterhout wrote:
On Sun, Dec 04, 2005 at 02:09:53PM +0300, Anton Nikiforov wrote:
Sorry for my stupidity but, maybe there is a function that converts mask
stored in int format to a numer of bits? ;)
Your function easyly convert this mask to dot decimal notation, but how
to count
Martijn van Oosterhout wrote:
On Sun, Dec 04, 2005 at 03:21:47PM +0300, Anton Nikiforov wrote:
Martijn van Oosterhout wrote:
Let i be your input.
Calculate t = -i.
If i is in the right format, t will have exactly one bit set.
Test this with t <> 0 and (t & i) == t
If that'
And the result i need:
idparent data
6 2root's chield 2 chield 2
2 0root's chield 2
0 0root
1 0root's chield 1
4 1root's chield 1 chield 2
i know that it is possible in Oracle but what abo
red started point of the tree getting a full path
to the required finish.
Best regards,
Anton Nikiforov.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PRO
a
>> 6 2root's chield 2 chield 2
>> 2 0root's chield 2
>> 0 0root
>> 1 0root's chield 1
>> 4 1root's chield 1 chield 2
>>
>> i k
chield 1 chield 1
>> >> 4 1root's chield 1 chield 2
>> >> 5 2root's chield 2 chield 1
>> >> 6 2 root's chield 2 chield 2
>> >>
>> >> And i want to get something like this:
>> &
Thanks Joe,
But this function is not giving a path from one element to other, it
is just truncating the tree beginning from the start element, but it
is not rotating the whole tree making starting element a tree's root.
JC> See contrib/tablefunc for a function called connectby().
Regards,
Anton
Dear all,
i have a problem with insertion data and running post insert trigger
on it.
Preambula:
there is a table named raw:
ipsrc | cidr
ipdst | cidr
bytes | bigint
time | timestamp
Triggers:
daily_trigger AFTER INSERT OR UPDATE ON raw FOR EACH ROW EXECUTE PROCEDURE
daily_func()
and the
Thanks Graeme!
MG> http://marc.theaimsgroup.com/?l=postgresql-sql&m=106739176106877&w=2
But this function is still returning only a subtree and in addition it
have a bug when calling it like
SELECT * FROM crawl_tree(0,0);
You will always get ERROR: out of memory
But this function is clear enough t
hield 2
ANlr> And i want to get something like this:
ANlr> start point "root's chield 2 chield 2"
ANlr> finish "root's chield 1 chield 1"
ANlr> And the result i need:
ANlr> idparent data
ANlr> 6 2root's chield 2 chield 2
ANlr>
Hello Bob!
Everybody knows that PostgreSQL is better than MySQL and supports more
features etc. But remember - the main issue of database systems now is
web that is being build mainly by students that do not even know what
database engines are made for. At least here (My second job is
Instructor in
Dear sirs,
Does someone made PL/Ruby working on 4.7.1?
I tried alot of things. Manual install, port install and nothing happend.
Please give me the idea how to fix the problem with
plruby.c: In function `pl_tuple_put':
plruby.c:498: error: too few arguments to function `tuplestore_begin_heap'
plrub
data?
--
Best regads,
Anton Nikiforov
smime.p7s
Description: S/MIME Cryptographic Signature
Anton Nikiforov пишет:
Dear All!
I have a question about how the PostgreSQL will manage a huge number
of raws.
I have a projet where each half an hour 10 millions of records will be
added to the database and they should be calculated, summarized and
managed.
I'm planning to have a few se
Francisco Reyes ?:
On Thu, 18 Mar 2004, Anton Nikiforov wrote:
But i'm worry about mentioned centeral database that should store 240
millions of records daily and should collect this data for years.
I have not worked with anything even remotely so big.
A few thougths..
I think
erformance.
--
Best regads,
Anton Nikiforov
smime.p7s
Description: S/MIME Cryptographic Signature
Dear All,
I have a database which stores traffic data and to update the traffic
for the particular IP i have to select this ip from the table for this
period and if it is already in the database i should run an update
statement, but if it is not presented - i should insert the data. It was
OK w
Hello David, thanks, changing to Ruby18 solved my problem after some
manual passages with woodoo around the computer :)
Best regards,
Anton Nikiforov
David Garamond wrote:
Anton Nikiforov wrote:
Thanks, David, but i did try this way already and in the case i build
plruby like this i have the
Paul Thomas пишет:
On 29/04/2004 09:53 Anton Nikiforov wrote:
looks like after a few tests that i've done i'm confused more than
before.
I did create a table and inserted 20 random records of two
different types of data into it.
Did you analyze the table afterwards?
Hello and than
me compact type for XML storing? (i know that
i could pack it and store in zipped or other format, but i would like to
have a search possibility);
--
Best regads,
Anton Nikiforov
smime.p7s
Description: S/MIME Cryptographic Signature
Thanks for the replay, Richard.
Richard Huxton wrote:
Anton Nikiforov wrote:
Dear All,
I have made a trigger procedure that logs all table's changes to the
log_table in XML format, but i do need to log a user who did that and
not succsessful with this.
The documentation (including &
have a database
consistency based on sequences).
Best regards,
Anton Nikiforov
smime.p7s
Description: S/MIME Cryptographic Signature
[EMAIL PROTECTED] wrote:
hi,
I want to track every change made to several tables...and was wondering
what is the best way... What are my thoughts at the moment are to make a
table like this :
id, table_name, field_name, old_value, new_value, timestamp
and triggers to do the logging.
but this will
Dear All!
in my system i would like to use the pg user's usesysid as a key in my
tables.
But it is not allowed (that was many times described here and in the
documentation)
But what can i do to get my tables and data to be consistent with the
system catalogue?
Could you please supply me with a r
29 matches
Mail list logo
