Devil™ Dhuvader wrote:
its like sum up entries of each user in order table backwards (i.e
from last entry to the first) and find the entry that has sum > $500.
If there is some user who didnt even make 500 till now in my shop return
the first date of transaction/order .
ex:
Orders(order_id,
2008/11/7, Devil™ Dhuvader <[EMAIL PROTECTED]>:
> its like sum up entries of each user in order table backwards (i.e from last
> entry to the first) and find the entry that has sum > $500.
> If there is some user who didnt even make 500 till now in my shop return the
> first date of transaction/ord
Andreas Joseph Krogh <[EMAIL PROTECTED]> writes:
> Needless to say that it would be nice if this information was available in
> the information_schema, I'm probably not the only one spending lots of time
> in there. It's probably not in in the standard, but i would be a nice
> PG-extention to al
On Friday 07 November 2008 21:09:33 Tom Lane wrote:
> Andreas Joseph Krogh <[EMAIL PROTECTED]> writes:
> > AFAICS this lists all tables which have a column named '?', which is not
> > what I'm after. I'm after listing all columns referencing a certain column
> > as a FOREIGN KEY.
>
> Should be p
Andreas Joseph Krogh <[EMAIL PROTECTED]> writes:
> AFAICS this lists all tables which have a column named '?', which is not what
> I'm after. I'm after listing all columns referencing a certain column as a
> FOREIGN KEY.
Should be possible to dredge that out of pg_constraint ... about like
this:
On Friday 07 November 2008 15:15:49 paulo matadr wrote:
> Try this
>
> select table_schema, table_name
> from information_schema.columns
> where table_schema not in
> ('information_schema','pg_catalog')
> and column_name = '?'
AFAICS this lists all tables which have a column named '?', which is n
its like sum up entries of each user in order table backwards (i.e from last
entry to the first) and find the entry that has sum > $500.
If there is some user who didnt even make 500 till now in my shop return the
first date of transaction/order.
ex:
Orders(order_id, user_id, amount_paid, create_t
On Fri, Nov 7, 2008 at 9:36 AM, paulo matadr <[EMAIL PROTECTED]> wrote:
> I change form to create query but basically need
> sum(rgat.rgat_tmencerramento - rgat.rgat_tmregistroatendimento) = result in
> hours
> sumary:
> rgat.rgat_tmencerrament = timestamp column
> gat.rgat_tmregistroatendimento =
I change form to create query but basically need
sum(rgat.rgat_tmencerramento - rgat.rgat_tmregistroatendimento) = result in
hours
sumary:
rgat.rgat_tmencerrament = timestamp column
gat.rgat_tmregistroatendimento = timestamp column
De: Osvaldo Kussama <[EM
Select sum(age(rgat.rgat_tmencerramento, rgat.rgat_tmregistroatendimento))
from atendimentopublico.registro_atendimento rgat
inner join cadastro.localidade loca on loca.loca_id=rgat.loca_id
inner join atendimentopublico.solicitacao_tipo_especificacao step on
step.step_id=rgat.step_id
where
date(rg
Try this
select table_schema, table_name
from information_schema.columns
where table_schema not in
('information_schema','pg_catalog')
and column_name = '?'
De: Andreas Joseph Krogh <[EMAIL PROTECTED]>
Para: pgsql-sql@postgresql.org
Enviadas: Quinta-feira, 6 de N
Is there a way to create custom type input/output
functions for user-defined types in some other
language except C (e.g. plythonu)?
Best regards
--
Markus Schatten, MSc
Faculty of Organization and Informatics
Varaždin, Croatia
http://autopoiesis.foi.hr
--
Ova poruka poslana je s CARNeto
12 matches
Mail list logo
