I have a period of consultation with Fecha1 and Fecha2
and two tables with the follow data:
Table1
|Clave_activo | Cantidad | fecha |
| | | |
| clave1 |5 | 01/02/00 |
| clave3 |7 | 05/05/01 |
| clave1 |2 | 03/09/
Postgresql 7.1.3-2
Red Hat 7.2
I've noticed that if I create a sequence, and then
do a select on it using nextval() everything works fine. However, if I drop the
sequence and then create it again, the same select statement generates a
NOTICE.
Is this normal behaviour or a bug? See below.
On Thu, Oct 10, 2002 at 09:37:49AM -0300, 2000 Informática wrote:
> Hi,
>
> I have two data bases: db1 and db2.
> In MS SQL Server I can use
> 'SELECT T1.ID, T2.NAME FROM db1..table1 T1 INNER JOIN db2..table2 T2
> ON T1.ID = T2.ID ...'.
>
> How I do it in the PosgreSQL ?
>
> HELP ME, PLEASE !
On Thu, Oct 10, 2002 at 09:37:49 -0300,
2000 Informática <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two data bases: db1 and db2.
> In MS SQL Server I can use
> 'SELECT T1.ID, T2.NAME FROM db1..table1 T1 INNER JOIN db2..table2 T2
> ON T1.ID = T2.ID ...'.
>
> How I do it in the PosgreSQL ?
Po
Hi,
I have two data bases: db1 and db2.
In MS SQL Server I can use
'SELECT T1.ID, T2.NAME FROM db1..table1 T1 INNER
JOIN db2..table2 T2
ON T1.ID = T2.ID ...'.
How I do it in the PosgreSQL ?
HELP ME, PLEASE !
Sorry,
I'm a Brazilian and I don't speak and write English
very well !
Sil
select t0_o.scheduler_action_id from scheduler_action t0_o where
t0_o.is_done = 0 and t0_o.invocation_date <= 1034033214921::numeric;
seems to work in
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
The reason that this query worked in hpux without the explicit
casting is maybe hp
> CREATE TABLE "scheduler_action" (
>"scheduler_action_id" numeric(30) NOT NULL,
>"action_type" numeric(4) NOT NULL,
>"priority" numeric(4) NOT NULL,
>"referenced_id"numeric(30) NOT NULL,
>"invocation_date" numeric(30) NOT NULL,
>"is_done"
On Thu, 10 Oct 2002, Ludwig Lim wrote:
> Hi :
>
> 1) How do I view the body of a stored procedure in
> psql?
SELECT prosrc from pg_proc where proname = 'your pl/pgsql procedure name';
>
> 2) How do I know get the corresponding stored
> procedure of a particular trigger in psql?
>
SELECT t.
Hi :
1) How do I view the body of a stored procedure in
psql?
2) How do I know get the corresponding stored
procedure of a particular trigger in psql?
thanks in advance,
ludwig.
__
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
htt
