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
from a table. I have a Datum which
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 small. I'd just hardcode them.
--
Alvaro
of the inbuilt type? That should be quite easy to do in just a few lines
of code.
cheers
andrew
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--Imad
---(end of broadcast)---
TIP
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 clauses like
?
--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=# select to_char(2147483648,'999,999,999');
WARNING: detected write
(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
---(end of broadcast
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 variable in a block
and quickly
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 here?
--Imad
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
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 avoid initializing automatic
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
initialization section. My two cents!
--Imad
www.EnterpriseDB.com
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 want to assign it a value immediately
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 We have been
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?
It is from
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's
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