Re: Setting a field to default if blank value
От | Karen Grose |
---|---|
Тема | Re: Setting a field to default if blank value |
Дата | |
Msg-id | 7391E3F2BADAEA43889BA0CEC76364A2AC9D26@vigilosnt обсуждение исходный текст |
Ответ на | Setting a field to default if blank value ("Robert Fitzpatrick" <robert@webtent.com>) |
Список | pgsql-general |
Robert, I use a default value on columns that I define as not null and want particular data to be inserted if no value is supplied. After you create your table a simple alter statement is all you need: alter table table_name alter column column_name set default ' '; Hope this helps Karen Grose Vigilos Inc. -----Original Message----- From: Robert Fitzpatrick [mailto:robert@webtent.com] Sent: Monday, April 28, 2003 11:09 AM To: gearond@cvc.net Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Setting a field to default if blank value > Robert Fitzpatrick wrote: > > Looking for the best way of handling this, would like to do > it in the > > database and not in my apps. I set a field to 'Not Null', but if a > > blank value comes in, the field will accept it as just > that, a blank > > string. How can avoid this using a trigger or function? I thought > > about a function that would check the field and then place > a trigger, > > but that gets to be a lot of functions and triggers for different > > fields. Is there a way to pass a field name to the function? (in > > plpgsql) > > > > Or what is the best way to handle this for many different fields in > > many tables? > If you mean blank like '', then if the field is a string, it > would be normal behavior as is. > Yes, they are strings (varchar). Know the best way to handle it? -- Robert ---------------------------(end of broadcast)--------------------------- TIP 3: 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
В списке pgsql-general по дате отправления: