Updating timestamps

I have a simple query:

select true,78,'Here is a value' as stringfield, testname from tbltest;

it returns:
true as bool
78 as int4
and the string 'Here is a value' as Unknown

Why is it that all the values besides the string come back with the
correct type?
what is a simple string being returned as unknown instead of varchar or
text?

Thanks,

Tony

I have a Red Hat EL 4 server and they only ship 7.x with it, but I want
to run 8.x on it.
The server is running in 64bit mode and was wondering if there is a RPM
available? (I could only find 32bit ones on the Postgresql web page)

Thanks,

Tony

Tony Caduto wrote:

I have a simple query:

select true,78,'Here is a value' as stringfield, testname from tbltest;

it returns:
true as bool
78 as int4
and the string 'Here is a value' as Unknown

Why is it that all the values besides the string come back with the
correct type?
what is a simple string being returned as unknown instead of varchar or
text?

Because it doesn't know what you want it as :) For example in 8.0.3:

template1=# select true,78,'Here is a value' as stringfield;
bool | ?column? | stringfield
------+----------+-----------------
t | 78 | Here is a value
(1 row)

Or

template1=# select true,78::int4,'Here is a value'::text as stringfield;
bool | int4 | stringfield
------+------+-----------------
t | 78 | Here is a value
(1 row)

Sincerely,

Joshua D. Drake

Thanks,

Tony

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Tony Caduto wrote:

I have a Red Hat EL 4 server and they only ship 7.x with it, but I want
to run 8.x on it.
The server is running in 64bit mode and was wondering if there is a RPM
available? (I could only find 32bit ones on the Postgresql web page)

Just download the source RPM and:

rpmbuild -bb --target=i686 src.rpm

Sincerely,

Joshua D. Drake

Thanks,

Tony

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Hi,
I don't think I was clear enough.

I know about using the AS keyword, that is not the problem.
The query in issue is:

select true,78,'Here is a value' as stringfield, testname from tbltest

Is returning the string as TYPE Unknown, not the column name. The
column name comes back as stringfield because of the AS keyword.

You can see the type in tools such as PG Admin etc

Thanks,

Tony

Hi Joshua,

Forgive me but I am not normally a redhat user (normally Gentoo)

So it will build a 64bit binary by default, there is no editing of the
spec file or anything else required?

Thanks,

Tony

Tony Caduto wrote:

Hi Joshua,

Forgive me but I am not normally a redhat user (normally Gentoo)

So it will build a 64bit binary by default, there is no editing of the
spec file or anything else required?

Oh if you are using 64bit then just:

rpmbuild -bb --target=x86_64 src.rpm

You may need to add some rpms in advance such as:

openssl-devel
rpm-build

But once your depends are resolved yes you should be good to go.

Sincerely,

Joshua D. Drake

Thanks,

Tony

Just download the source RPM and:

rpmbuild -bb --target=i686 src.rpm

Sincerely,

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

On Mon, Aug 08, 2005 at 03:05:13PM -0500, Tony Caduto wrote:

Hi,
I don't think I was clear enough.

I know about using the AS keyword, that is not the problem.
The query in issue is:

select true,78,'Here is a value' as stringfield, testname from tbltest

Is returning the string as TYPE Unknown, not the column name. The
column name comes back as stringfield because of the AS keyword.

What about the query:

select 't','78','Here is a value' as stringfield, testname from tbltest

This gives you three Unknown fields. PostgreSQL can't know that the
first is to be a bool or that the second is to be an int until you
actually give it a type. Usually via casting or by inserting into a
table/

Single quotes denote an untyped constant, not a string.

Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Thanks for your help Joshua.

I will give it a try.

Tony

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Mon, 8 Aug 2005, Tony Caduto wrote:

I have a Red Hat EL 4 server and they only ship 7.x with it, but I want to
run 8.x on it.
The server is running in 64bit mode and was wondering if there is a RPM
available? (I could only find 32bit ones on the Postgresql web page)

I double-checked and realized that we have no servers to build 64-bits
RPMs for RHEL 4. I've built ones for RHEL 3.0, but they may not work for
you.

If you can succeed building the RPMs as Joshua guided, please let me know
and we can upload the binaries to FTP site.

If anyone is interested, RHEL 3.0 x86_64 RPMs will be available in main
FTP site in an hour.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFC98jttl86P3SPfQ4RAs4eAJ9V827OJyj/3RBioS1XnNwI891oMwCg6oQr
XGK3gi/FWstkFe/5tW9vITA=
=IqzT
-----END PGP SIGNATURE-----

I always thought that single qoutes in a sql statement meant a
string/varchar/text.
Thanks for the info on this.

Hi,

I double-checked and realized that we have no servers to
build 64-bits RPMs for RHEL 4. I've built ones for RHEL 3.0,
but they may not work for you.

If you can succeed building the RPMs as Joshua guided, please
let me know and we can upload the binaries to FTP site.

As promised: I put them on http://opensource.nederland.net/PostgreSQL/

- Sander.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Sander,

On Tue, 9 Aug 2005, Sander Steffann wrote:

If you can succeed building the RPMs as Joshua guided, please
let me know and we can upload the binaries to FTP site.

As promised: I put them on http://opensource.nederland.net/PostgreSQL/

Thanks a lot :)

I've uploaded the RPMs to main FTP site (under
/pub/binary/v8.0.3/linux/rpms/redhat/rhel-4-x86_64). They will be
available in an hour. Also they will be on the mirrors after first sync.

Regards,

- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFC+Gfetl86P3SPfQ4RAqvQAJ41lWs2wuZ+sI6iiNlQgf7X+IIlOwCfXP4N
zMflttn5SqzjadfJRqbyLkc=
=aiR7
-----END PGP SIGNATURE-----