On Thu, Feb 10, 2005 at 17:45:11 -0500,
Johnny C <[EMAIL PROTECTED]> wrote:
>
> How can you make month (append) - 01 - (append) year? and
> pass that as a condition to the field date? Is this possible?
You can EXTRACT the day of the month from the date. If you need this
to use an index, you can
I have the following tables:
TABLE A
month | year | item | num
1 2005 myitem 003
TABLE B
num| date | descr
003 02-01-2005 blahblah
003 01-01-2005 toratora
I am trying to come up with something li
I am trying to use a different drive for the data.
I have edited postgres.conf to point to the new location, but I get the
error /pgdata/PG_VERSION is missing.
Do I have to do a initdb?
When I try an initdb it says it is not empty. (has lost and found folder in
it).
Fedora Core 3 linux.
I was able
I am trying to use a different drive for the data.
I have edited postgres.conf to point to the new location,
but I get the error /pgdata/PG_VERSION is missing.
Do I have to do a initdb?
When I try an initdb it says it is not empty. (has lost and
found folder in it).
Fedora Core 3 linux.
> So it should work to do "SELECT int4($1::bit varying)" and then pass
> 'xBEEF' as the string value for the parameter.
>
> regards, tom lane
Thanks, that worked for me
---(end of broadcast)---
TIP 3: if posting/reading thro
