On 6 Dec 2009, at 4:13, Scott Marlowe wrote:
> On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
> wrote:
>> Hello all,
>>
>> I'm trying to do a crosstab from data that row names are times.
>>
>> These times are timestamps and i want to use they truncating to minutes
>> this works f
Hello,
has anyone ever implemented something similar to postgresql_autodoc in Python?
TIA,
Sincerely,
Wolfgang
--
NO "Courtesy Copies" PLEASE!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
Richard Broersma escribió:
On Sat, Dec 5, 2009 at 11:11 AM, Jose Maria Terry Jimenez
wrote:
select distinct date_trunc('minute',"timestamp") as "timestamp" from
historico order by "timestamp";
Notice the example from the documentation:
http://www.postgresql.org/docs/8.4/interactive/f
Scott Marlowe escribió:
On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
wrote:
Hello all,
I'm trying to do a crosstab from data that row names are times.
These times are timestamps and i want to use they truncating to minutes
this works for me:
select distinct date_trunc('mi
Alban Hertroys escribió:
On 6 Dec 2009, at 4:13, Scott Marlowe wrote:
On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
wrote:
Hello all,
I'm trying to do a crosstab from data that row names are times.
These times are timestamps and i want to use they truncating to minute
Sim Zacks writes:
> If I replace that column with -1::numeric(20,4) or - (1::numeric(20,4))
> the type that goes to the view is numeric without any scale or precision
> and then I get an error that I cannot change the column type.
You've still got the order of operations wrong.
(-1)::nume
2009/12/6 José María Terry Jiménez :
>
> Thank you very much. This worked, also worked with ' instead $outer$ BUT
> escaping the ' in minute with two of them ' 'minute' '.
>
> What does $outer$ or when i must use it?
It's a type of quoting... Take a look here:
http://www.postgresql.org/docs/8.3
RE all below: (hand assembled reply)
I looked through all the documentation, and I did not find 'WITH UPDATE' as
part of any transaction type, so I didn't end up using that information.
For the record, (in the mail lists), I am using symfony/Doctrine ORM. I used
something like this:
try {
Hi,
I have used Postgres on windows, but now I need to develop a website in
Linux envoirnment.
I have installed Ubuntu Desktop, but now I need to know what packages
install to get Postgres working.
Best Regards,
André.
On 06/12/2009 21:35, Andre Lopes wrote:
> I have used Postgres on windows, but now I need to develop a website in
> Linux envoirnment.
>
> I have installed Ubuntu Desktop, but now I need to know what packages
> install to get Postgres working.
I think Ubuntu's packaging system is based on the De
Hi,
Thanks for your reply.
I have installed postgresql 8.3, and now, what I need to do to get things
working? Install PGAdmin? Or there are other steps I need to do to get
things working? For example, how can I define the password for access as
sysadmin?
Best Regads,
On Sun, Dec 6, 2009 at 9:48
Andre Lopes wrote:
Hi,
Thanks for your reply.
I have installed postgresql 8.3, and now, what I need to do to get
things working? Install PGAdmin? Or there are other steps I need to do
to get things working? For example, how can I define the password for
access as sysadmin?
yourusername $
Andre Lopes a écrit :
> Hi,
>
> Thanks for your reply.
>
> I have installed postgresql 8.3, and now, what I need to do to get
> things working? Install PGAdmin? Or there are other steps I need to do
Daemons are active as soon as installation is completed.
> to get things working? For example,
Hi,
I've encountered a serious Postgres bug which apparently has a fix
that hasn't been released in a patch. How or where can I look up its
status?
This is a serious bug- it basically renders RETURN QUERY useless in
any environment where you don't have the option of dropping and
re-creating a ta
14 matches
Mail list logo
