On Wed, Jun 28, 2006 at 08:56:31 -0700,
[EMAIL PROTECTED] wrote:
> * tbl_data_type : contains the data type of the profile, their id
> and their names. E.g.: id=1, data type name="last name"; id=2,
> data type name="address", and so on
> * tbl_data : the data of all the profil
Hi,
filippo wrote:
> I have two tables like these: (this is an example, the actual tables
> have diffferent fields and meanings)
>
> TABLE1
> id
> person_name
> date_arrival
> date_departure
>
> TABLE2
> id
> car_description
> date_arrival
> date_departure
>
> I'd like to make a query to have s
"Daniel Caune" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION foo(i IN int)
> RETURNS void
> AS $$
> BEGIN
> UPDATE bar
> SET i = i; // column i = parameter i
> END;
> $$ LANGUAGE PLPGSQL;
In SELECTs you can qualify the column, ie, bar.i vs i. That doesn't
work for an UPDATE tar
Hi,
Is there a way to specify a local variable/parameter within a query
where a column has the same name than the local variable/parameter?
Example:
CREATE OR REPLACE FUNCTION foo(i IN int)
RETURNS void
AS $$
BEGIN
UPDATE bar
SET i = i; // column i = parameter i
END;
$$ LANGUAGE PLPGSQL;
> I am using windows xp operating system...
> I want to know how to connect remote postgresql from my system.. I need
> brief description from beginning..
> Now I am using pg_HBF conf file to connect remote postgresql in that I
> am giving host name , ip-address,mask and trust... but it is showing
Hi
I am using windows xp operating system...
I want to know how to connect remote postgresql from my system.. I need
brief description from beginning..
Now I am using pg_HBF conf file to connect remote postgresql in that I
am giving host name , ip-address,mask and trust... but it is showing
error
> If u don't mind can u please tell me clearly.. where I have start -I or
> how to start postgresql with -I
> > I am using postgresql database server... in my system.. if I want to
> > connect to this database server from other system..Or how can I use
> this
> > database server in other machine
Hello again,
I did some research on your suggestions with Slony-I and logshipping, one
major drawback we just realized is that the server where postgres will sit
on runs Windows XP. Our client has this techie that only knows how to manage
a windows box, and he runs some other services that we cann
> I am using postgresql database server... in my system.. if I want to
> connect to this database server from other system..Or how can I use this
> database server in other machine ..
>
> How can I do this..if any one have idea about this please give me brief
> description
You need to start the
Parang Saraf wrote:
hey,
I wanted to know about graph plotting engine that is compatible with
postgres 8.1.4. I am performing some queries like :
Comparing the speed of three runners namely A, B and C versus time. I
want to publish the result in a graphical manner on the net instead of
just
Hi good afternoon to every one..
I am using postgresql database server… in my system..
if I want to connect to this database server from other system..Or how can I use
this database server in other machine ..
How can I do this..if any one have idea about this please
give me brief desc
11 matches
Mail list logo
