What do you want to print? The integer value or the date string like
"29-01-2008". Use the date_out function to convert your value to date.
--Imad
On Tue, Nov 4, 2008 at 10:19 AM, Zhe He <[EMAIL PROTECTED]> wrote:
> Hi,
> I met some problem with get date type value
> fro
I'd include catalog/pg_type.h and use the #DEFINE for that.
--Imad
On Tue, Jul 8, 2008 at 10:16 AM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> Stephen R. van den Berg wrote:
>
>> How large is the probability of these numbers ever changing?
>
> Really s
ouble, if you forget one.
> >
> >
> >
> Do you really need a new datatype or just to change the output behaviour
> of the inbuilt type? That should be quite easy to do in just a few lines
> of code.
>
> cheers
>
> andrew
>
> ---
nt to take this weight value all the way
upto the executor.
--Imad
www.EnterpriseDB.com
On 7/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all,
I want to pass additional weight info from the WHERE clause to the executor and
I hope someone can help me with this.
I accept claus
a change for a patch ?
--Imad
www.EnterpriseDB.com
On 6/29/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Patrick Welche <[EMAIL PROTECTED]> writes:
> With today's CVS code (originally noticed with 8.2beta3), on a PC where
> INT_MAX=0x7FFF=2147483647
> postgres=# selec
]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Parameters can be renamed in 8.2.
The only thing which does not work is renaming a variable immediately after
its declaration which is a useless functionality.
So, should we still consider it a ToDo?
-- Imad
www.EnterpriseDB.com
-
On 2/1/07, Tom Lane <[EMAIL PROTECTED]> wrote:
imad <[EMAIL PROTECTED]> writes:
> OK, so renaming does not work in the same block.
> You can rename a vairable in a nested block and thats why it works for
OLD/NEW.
> BTW, what is the purpose behind it? Declaring a vari
OK, so renaming does not work in the same block.
You can rename a vairable in a nested block and thats why it works for OLD/NEW.
BTW, what is the purpose behind it? Declaring a variable in a block
and quickly renaming it does not make sense to me.
--Imad
www.EnterpriseDB.com
On 1/31/07, Bruce
I was testing the following statement and found it working fine on
version 8.2.1.
"Fix RENAME to work on variables other than OLD/NEW"
I can rename just any variable declared in a PL block apart from
OLD/NEW. Is the TODOs list out of sync or I am missing the point her
On 11/3/06, Tom Lane <[EMAIL PROTECTED]> wrote:
imad <[EMAIL PROTECTED]> writes:
> Well, its about the coding style. And I doubt there exists a data type
> which may not have
> an initializer. A NULL / Zero is an option in all cases and you can do
> whatever you w
ite them as assignments after the statement acquiring the
table lock.
Well, its about the coding style. And I doubt there exists a data type
which may not have
an initializer. A NULL / Zero is an option in all cases and you can do
whatever you want to assign it a value immediately after the
init
Shouldn't we turn on warnings by the compiler on uninitialized
variables? This can also be helpful.
--Imad
www.EnterpriseDB.com
On 11/2/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I've noticed a trend in the PostgreSQL code base - for some reason, we tend
to av
Carefully check all the palloc's you are doing in your code.
This warning is shown when you write some extra bytes to the memory
and size of your data goes beyond the allocated size.
--Imad
EnterpriseDB (www.enterprisedb.com)
On 11/1/06, luis garcia <[EMAIL PROTECTED]> wrote:
Hi W
Release 6.5 brings MVCC to PostgreSQL.
Check out the following doc for details
http://www.postgresql.org/docs/7.1/static/release-6-5.html
--Imad
EnterpriseDB
(http://www.enterprisedb.com)
On 10/23/06, Gevik Babakhani <[EMAIL PROTECTED]> wrote:
Folks,
How long are we supporting MVCC?
hi,
I want to know is there any way to execute an anonymous PL/pgSQL block
in PostgreSQL.
Thanx
--
Regards
Imad
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column&#
Can anyone please tell me where in the source code, I can find the
compelte query.
--
Regards
Imad
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
16 matches
Mail list logo
