beginne' - inserting a record

On Sat, Dec 03, 2005 at 09:48:42PM +0100, Andrew Toth wrote:

MediaBin=# insert into media values ("000", 120, "00001");
ERROR: column "000" does not exist

What the Hell could be wrong?

Your quotes. Use ' and that command will work.

Peter

I'm not familiar with version 8.1; however, you to use single quotes, not
double quotes as in:

INSERT INTO media VALUES ('000', 120, '00001');

That should work...

On Saturday 03 December 2005 03:48 pm, Andrew Toth saith:

On 3 Dec 2005 at 21:48, Andrew Toth wrote:

MediaBin=# insert into media values ("000", 120, "00001");
ERROR: column "000" does not exist

I think you should use single-quotes rather than doubles:

insert into media values ('000', 120, '00001');

--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
rod@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

thx,

it's working!

And the last question - today:

how can i change the orter of the fields in a table?

2005-12-03, szo keltezéssel 20.59-kor Raymond O'Donnell ezt írta:

On 3 Dec 2005 at 21:48, Andrew Toth wrote:

MediaBin=# insert into media values ("000", 120, "00001");
ERROR: column "000" does not exist

I think you should use single-quotes rather than doubles:

insert into media values ('000', 120, '00001');

--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
rod@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

--

Tisztelettel: / Grüße / Yours sincerely,
Andrew Toth

Andrew Toth <tothaa@chello.hu> schrieb:

thx,

it's working!

And the last question - today:

how can i change the orter of the fields in a table?

If you have a table with field1, field2, field3, and you want to see
this table as field3, field2, field1, simple do 'select field3, field2,
field1 from table'.

Btw.: TOFU (top posting with fullquote below) are silly.

HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�

dont use " user '

Andrew Toth wrote: