Hi the list !
How can I make a test on a int2vector ? If I have a vector that contains
(1, 2, 5, 9), how can I check these values incivicually ? Thanks by
advance for your help.
--
David BOURIAUD
--
In a world without walls or fences, what
Hi folks,
I have a special application that considers a playday to be from 8am to
3pm the next morning. The system then does maintenance from 3am till 8am
(if necessary).
I'd like to ease application development by creating a new kind of
"playDay" to query from. For example:
SELECT * FROM tab
Limlim,
Please post table definitions and some sample data. Your problem does
not look that challenging and there is probably a simple reason that
you're having trouble with it.
> i am trying to build a query in sql that compares between 2 tables
> one
> hold to field and the other hold the 2 f
As I know, plperl doesn't support that yet.
plpgsql does, so does pltcl.
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Tue, 5 Jun 2001, clayton cottingham wrote:
> hello:
>
>
clayton cottingham <[EMAIL PROTECTED]> writes:
> how does one execute an sql statement from inside a plperl function?
At the moment, one doesn't.
This is one of a number of features that have to be finished before
plperl can be classed as more than a proof-of-concept exercise.
However, Mark Holl
On Wed, 30 May 2001, Nicolas wrote:
> Hi,
>
> I'm trying to retreive DISTINCT Values from a two colomn table called
> "Books". The colomns are named "Author" and "URL".
> DISTINCT values should be retieved from the "Author" Colomn , and then I
> should be able to retrieve the corresponding URL.
hello:
how does one execute an sql statement from inside a plperl function?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
There is currently no ability to span databases in a single
query.
On Wed, 30 May 2001, Muhammed Yazici wrote:
> hi,
> i'am really new to postgresql and i try it with php ..
>
> Now i have following question :
>
> is it possible to make one query on two databases. I have a database calles
> d
...sh*
But thanx ..
i'll try another solution ..
"Nils Zonneveld" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
> Muhammed Yazici wrote:
> >
> > hi,
> > i'am really new to postgresql and i try it with php ..
> >
> > Now i have following question :
>
find libpq.so.2.1 in the tree from the compile (find . -name
libpq.so.2.1 -print)
then copy it to /usr/libexec manually.
you might also want to check the permissions on the library, it should be
755 (rwxr-xr-x).
Best regards,
Chris
- Original Message -
From: "Dorin Grunberg" <[EMAIL PROT
Muhammed Yazici wrote:
>
> hi,
> i'am really new to postgresql and i try it with php ..
>
> Now i have following question :
>
> is it possible to make one query on two databases. I have a database calles
> db1 and one db2 and i want to get :
>
> select * from ":db1:table1" where ":db1:table
Try:
- The ILIKE operator, for example,
SELECT * FROM account WHERE username ILIKE "test";
- upper() or lower(), for example,
SELECT * FROM accont WHERE lower(username) = "test";
-
Andrew J. Perrin - Assistant Professor of Sociology
hi,
i'am really new to postgresql and i try it with php ..
Now i have following question :
is it possible to make one query on two databases. I have a database calles
db1 and one db2 and i want to get :
select * from ":db1:table1" where ":db1:table1:col1" in (select "col1" from
":db2:table1"
hi,
I wanted to know that does postgresql database support php-nuke
--
Donot rely on the Operating System which don't have any sources for.
-Seen somewhere on the Net
___ _ _ _
|_|_||_||_||\/||_|| \
_|| || || \| || ||_/
i am trying to build a query in sql that compares between 2 tables one
hold to field and the other hold the 2 fields in one
example:
table1:EN,12
table2:EN.12
how can i compare between the tables throw that field
i try with this query but it doesnt work:
SELECT * FROM dbo.CNT_DOC_LANGS x INNER JO
Greetings,
I am investigating whether our application will run on 7.1.1 (from
7.0.3), and our client software only accesses the database through views
for security and convenience.
In our client app, we lock our table before doing something to it.
Fortunately, in 7.0.3, a view looked like a
On Thu, 31 May 2001 17:24:54 + (UTC), [EMAIL PROTECTED] (Mark)
wrote:
>
>How does one perform date manipulation within SQL? For example, SQL
>Server has a dateadd() function that takes a date part, scalar, and the
>date to manipulate.
>
>I have a query that determines the number of days that
Hello:
I'm new user of postgresql. My problem is that:
1. How to create template table? Is it right of ' Create temptable
test(..)'?
2.My application is Client/Server, can I has some workstations create the
same template table name on the same time? If I could, How can I do with it?
Thank
If you use index on this table it's better to:
1) drop all index on the table
2) do the insert
3) (re)create the indexes
--
--
"L'idea di base è estremamente semplice..."
©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)
---(end of broadcast)---
read this:
http://www.postgresql.org/idocs/index.php?sql-createtrigger.html
bye
--
--
"L'idea di base è estremamente semplice..."
©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)
---(end of broadcast)---
TIP 4: Don't 'kill -9
> exemple:
> CRETAE TABLE Address (Number integer, Street varchar, city varchar, contry
> varchar);
> CREATE TABLE Person (Name varchar, addr Address);
> INSERT INTO addrerss VALUES ( 5, 'rue du pont', 'Lyon', 'France');
> The question is :
> How we can insert a new person whose address is that i
stone schrieb:
> Hello:
> I'm new user of postgresql. My problem is that:
> 1. How to create template table? Is it right of ' Create temptable
> test(..)'?
> 2.My application is Client/Server, can I has some workstations create the
> same template table name on the same time? If I could, How
Hi,
I'm trying to retreive DISTINCT Values from a two colomn table called
"Books". The colomns are named "Author" and "URL".
DISTINCT values should be retieved from the "Author" Colomn , and then I
should be able to retrieve the corresponding URL.
How do I build the SQL Query ?
I tried to use: "S
"Roy Souther" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
0105301102010Q.28903@OlympusMons">news:0105301102010Q.28903@OlympusMons...
> I am testing my SQL commands in pgaccess before I put them into my C++
code.
> Trying to copy a table using...
> SELECT * INTO TABLE copy_stuff FROM
read the doc section datatype!!!
serial just create a sequence on a standard way, if you dont like it you'll
have to create your sequence.
bye
--
--
"L'idea di base è estremamente semplice..."
©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)
---(end
>From pg_group, it's possible to return the users that are in that group.
How can in put the values in that array of integer to an array ??
Using plpg/SQL, how can i access to the array of integers ???
Best Regards
Luis Sousa
---(end of broadcast)---
chard <[EMAIL PROTECTED]> writes:
> hello i've got a problem on CREATE USER and ALTER USER when i have many
> users connected.
> i have prosgresql 7.1 running on Redhat 7.0
> is this a bug in postgres?
How can we tell? You'll need to provide a much more specific report
than that. See
http://www
hello i've got a problem on CREATE USER and ALTER USER when i have many
users connected.
i have prosgresql 7.1 running on Redhat 7.0
is this a bug in postgres?
pls let me know. thanks
richard.
---(end of broadcast)---
TIP 4: Don't 'kill -9'
28 matches
Mail list logo
