update table1 set price = table2.price
where table1.productId = table2.productId;
(Of course, both tables must have a different name).
:)
Ligia
""[EMAIL PROTECTED]"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> This is a multi-part message in MIME format
Ok. Got It. I thought that would help, also.
Thanks.
Ligia
"Stephan Szabo" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Mon, 26 Aug 2002, Ligia Pimentel wrote:
>
> > I've been having problems with a database
I've been having problems with a database in postgres 7.1, this database
worked just fine for about 6 months, but it is a fast growing database (a
lot of records inserted every day, almost none deleted).
The problem is that the database started corrupting indexes, and tables
(even system tables,
Yes we did. By the way, how often is it recomended?
Ligia
"mark carew" <[EMAIL PROTECTED]> wrote in message
akgr6p$vp2$[EMAIL PROTECTED]">news:akgr6p$vp2$[EMAIL PROTECTED]...
> Hi Ligia,
>
> Are you running VACUUM ANALYSE or is it VACUUM ANALYZE (can never
> remember, though reasonably sure t
I live in Guatemala, and our timezone is GMT -6, but my server (postgres 7.1
on a linux redhat 6.2) is storing the dates in the format
2002-07-24 00:00:00-04 ( I this understand represents GMT -4).
My linux servers gives me the the date and time correctly, so I know is not
a matter of the date o
You could also use describe (in psql environment )
psql mydatabase
mydatabase=# \d indexname
Index "indexname"
Attribute | Type
+---
fieldname| datatype
unique btree
The word "unique" will show up only if the index has the unique
qualification, otherwise it wi
> As a matter of fact I had to do this exercise just yesturday.
> I like it as I find I have much more freedom to gather data, organise it
> then insert it.
> It's easy to view the output of your selects on the screen and when
> happy do the insert(s).
>
> Hope this helps.
&
I don't know if this can be done...
In MSSQL Server I can access a table created in another database (on the
same server, of course) by using the following syntaxis...
select * from databasename..tablename where condition;
Can I do this in postgres?
I'm using version 7.2 on a redhat server...
wrote in message
news:[EMAIL PROTECTED]...
> Quoting Ligia Pimentel <[EMAIL PROTECTED]>:
>
> >
> > I have a problem with postgres, I'm running a query that joins two
tables,
> > one with 129000+ records, and the other with 1172 records, it's a very
> > simpl
I have a problem with postgres, I'm running a query that joins two tables,
one with 129000+ records, and the other with 1172 records, it's a very
simple join. But postgres can't handle it!!! (Both tables have an index on
the field "cuentacb").
I get the following error after 3 minutes...
migr
I need to know if there is a sql function implemented in postgres that gives
me a date plus any number of days, months or years (the traditional dateadd
function) or how to do it in sql?
Thanks in advance for any help
Ligia
---(end of broadcast)
When we execute this query in psql over linux, we don't get any errors
select sum(valor) as totalCR, count(correlativo) as docsCR, caja into tmp_cr
from transaccion as t, codigocaja as c
where c.codigo = t. codigo
and c.tipomov = 'CR'
group by caja;
select sum(valor) as totalDB, count(correlativ
Does anyone know if it is possible to make a FULL OUTER JOIN in Postgres 7?
Thank you for your help,
Ligia
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
13 matches
Mail list logo
