Thank you very much Joe.
Ezequias
Joe escreveu:
Hi Ezequias,
On Thu, 2007-03-22 at 16:43 -0300, Ezequias R. da Rocha wrote:
I must use a select * from some table but i must do a join and it must
be in the were clause.
I can't put select * from tabel1 as tb1, table2 as tb2
where t
Hi list,
I must use a select * from some table but i must do a join and it must
be in the were clause.
I can't put select * from tabel1 as tb1, table2 as tb2
where tb2.id = 2
and tb1.fk_tb2ID = tb2.id
I don't would like to use this select statement because the select
brings us both columns (
Perfect quite nice. I am doing things that I could not believe I could
do without the community.
Thank you so much.
--
Atenciosamente
Ezequias Rodrigues da Rocha
Richard Broersma Jr escreveu:
update myTable
set date = (current_date + (Select daysToAdd from base.Table1 where
myFKey_id = Tab
Hi list,
I must add some days (i.e:365) to my current_date and put it in my table
(an UPDATE). By now, it is simple but my "days to add" is in another table.
How could I do this kind of update
My sql is like this (but is not working):
update myTable
set date = (current_date + (Select daysToA
Guy Fraser escreveu:
On Wed, 2007-03-21 at 11:04 -0300, Ezequias R. da Rocha wrote:
Hi list,
I would like to know if postgresql has a Regular Expressions (Regex)
implemented already.
With it we could implement queries like
Select * from myClientes where name = 'E[zs]equias'
Hi list,
I would like to know if postgresql has a Regular Expressions (Regex)
implemented already.
With it we could implement queries like
Select * from myClientes where name = 'E[zs]equias'
where the result occurs even if the field has Ezequias or Esequias.
Regards
Ezequias
--
Hi list,
It is possible to change the Encode of one database while it is on ?
Sincerely
Ezequias
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi list,
Could someone tell me in a simple way what does Maintence DB means ?
Regards
Ezequias
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so tha
Ok I will use only on error ok ?
-l 0
:)
Thank you
Dave Page escreveu:
Ezequias Rodrigues da Rocha wrote:
Hi list,
I would like to know if I set the debug mode to 2 (-l 2) in the
pgAgent connection string it could spend much cpu processing.
I have other things running in the server and
scricao) VALUES ('2007-03-13
10:20:20','CardPass');
And it was in:
19485ms
Great don't you ?
Ezequias
Alvaro Herrera escreveu:
Ezequias R. da Rocha wrote:
Thank you all. The function from Jonah solves my problem.
Just a simple question:
One million of inserct
escreveu:
On Tuesday 13 March 2007 6:30 am, Ezequias R. da Rocha wrote:
I quetion one more time. I must have a function ? Isn't another way to
implement it without using functions ?
Ezequias
Bart Degryse escreveu:
Please post your complete CREATE FUNCTION statement. Error code 42601
r
Hi list,
I would like to test the power of processing of postgresql (and my
server) by insert a large ammount of data on a table I have.
I would like to know how to implement a For... loop . With it I think I
could check the real power of my server.
Ezequias
---(end
oping. To find it I need to see more code.
Please don't mail me directly. Only mail to pgsql-sql@postgresql.org
<mailto:pgsql-sql@postgresql.org>
>>> "Ezequias R. da Rocha" <[EMAIL PROTECTED]> 2007-03-13 14:19 >>>
They are not working well.
Allways the
e i in this case)
FOR i IN 1 .. 100 LOOP
statements
END LOOP;
>>> "Ezequias R. da Rocha" <[EMAIL PROTECTED]> 2007-03-13 14:00 >>>
Ezequias R. da Rocha escreveu:
> Hi list,
>
> I would like to test the power of processing of postgresql (and my
> server) by
Ezequias R. da Rocha escreveu:
Hi list,
I would like to test the power of processing of postgresql (and my
server) by insert a large ammount of data on a table I have.
I would like to know how to implement a For... loop . With it I think
I could check the real power of my server.
Ezequias
15 matches
Mail list logo
