Hello all,
I was recently asked to determine if PostgreSQL was Y2K compliant. Looking at
the questions archive, I found the following:
On April 13, 1998, Thomas G. Lockhart writes:
> For Postgres v6.3 (and earlier) the default date/time style is "traditional
> Postgres". In future releases, the
Are there any functions to work with arrays?
For example:
nr_of_elements(array)
insert_val_into_array(array, 'val')
delete_val_from_array(array, pos)
...
If not, it's pretty hard to work with arrays.
If I can't get the number of elements, how should I reference the
elements (if I know the number,
Hi,
I have 2 queries, which are quite similar:
a) select distinct p1.domain from dom_prot p1, identical p2, classification p3
where p2.reference = p1.protein
and p2.protein ~ 'EPA3_HUMAN'
and p3.domain = p1.domain;
b) select distinct p1.domain from dom_prot p1, identical p2, classifica
Hi, I' d really appreciate some help with the following issue:
I'm using libq++ for a C++ frontend; the problem is I need to have
many users who don't have accounts on the server. I tried to find
information on connecting to the database specifying the username and
password, b
Hi
ive compiled and installed postgres, did the initdb under
user postgres and so on. i think, there is nothing i didn't
pay attention to.
but when "createdb test" under user postgres or any other
user i get the following brainsmashing error:
Connection to database 'template1
Hi!
I'm use Apache 1.2.5/PHP3 and all working well,
but when I try use PostgreSQL functions
with Apache 1.2.6/PHP3 the httpd process
try core dumping. All anothe PHP3 functions
working well...
Simple test programs with libpq - Ok.
May be anybody can help me?
-
[EMAIL
> Hi,
>
> I have 2 queries, which are quite similar:
>
> a) select distinct p1.domain from dom_prot p1, identical p2,
> classification p3
>where p2.reference = p1.protein
>and p2.protein ~ 'EPA3_HUMAN'
>and p3.domain = p1.domain;
>
> b) select distinct p1.domain from dom_prot p1, id
