dbTalk Databases Forums  

Validation rules

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Validation rules in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert Morgan
 
Posts: n/a

Default Validation rules - 04-27-2004 , 05:53 PM






Hi, I have a postgresql database with a web interface and I need to
check that the data being entered is valid for the field. I am using PHP
for scripting, are there any postgres functions for creating validation
rules that I could use.

Hope this is clear enough

Bob


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


Reply With Quote
  #2  
Old   
joseph speigle
 
Posts: n/a

Default Re: Validation rules - 04-27-2004 , 06:08 PM






you can write your own but you would have to learn plpgsql which is a server-side sql on-top-of sql languages. Can you give an example? In brief, it may be faster to use php as you may be more familiar with that than with pl/pgsql .

On Wed, Apr 28, 2004 at 10:53:58AM +1200, Robert Morgan wrote:
Quote:
Hi, I have a postgresql database with a web interface and I need to
check that the data being entered is valid for the field. I am using PHP
for scripting, are there any postgres functions for creating validation
rules that I could use.

Hope this is clear enough

Bob


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
--
joe speigle
www.sirfsup.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.