Phone Number Validation in postgres

By Shankar Balachandran -
I took a simple number validation code across net and modified it to check phone numbers. It allows only numbers,plus symbol(+) and underscore(_) operators

-- Function: isphoneno(character varying)

-- DROP FUNCTION isphoneno(character varying);

CREATE OR REPLACE FUNCTION isphoneno(character varying)
  RETURNS boolean AS
$BODY$
BEGIN
    RETURN $1 ~ '^[0-9,+,-,.]+$';
END;
$BODY$
  LANGUAGE 'plpgsql' IMMUTABLE
  COST 100;
ALTER FUNCTION isphoneno(character varying) OWNER TO tad;

Comments

Post a Comment

Popular posts from this blog

Changing Timezone in Postgresql, Ubuntu

By Shankar Balachandran -
Image
Timezone and locale are integral concepts that one should be aware of when implementing a System. For example. if you create a database in PostgreSql, it will use the default System settings for the database. Lets say you have a server in UK and your client is US. If the client tries to retrieve the current date or time, it is going to show the UK time and not the US one.
Today I encountered a different issue in our client place where the Ubuntu timezone and PostgreSql timezone were showing a incorrect values. Instead of Indian Standard Time (IST) it was showing Pacific Daylight Time(PDT). These are the steps that I followed to change the timezone to IST in PostgreSql and Ubuntu.
Changing timezone in Ubuntu:
sudo dpkg-reconfigure tzdataYou will be prompted to choose the continent and then the area. Provided screen shots where we configure the location.
Use TAB key to navigate to the OK button and then press Enter.

The changes will get reflected immediately. To check it you can open a n…
Read more

Display Logic and read only logic In Openbravo

By Shankar Balachandran -
Using display logic in Openbravo is a primitive task but might seem a lot more difficult until you get hold of it...The display logic can be applied at the window-field level. Lets see a example. We have two fields married which is a check box and children which is a text box. Now at runtime we wish to display the children text box only if the married is ticked. So to apply this Logic we need to write a display condition in the children field. The logic is very simple. just type @married@='Y' in the display logic column of the field children.Now for read only logic, if you want the children field to be defaulted to 0 instead of hiding it, we need to do it at the table-column level. In the children column type@married@='Y' in the read only logic field and set the default value field as 0.
Read more

My 10 years in Application Development

By Shankar Balachandran -
It's been around 10 years since I started programming. May be a bit more, if I have to include my first attempts at C programming in school. But it would be a grave insult to call remembering ten lines of code and just replicating it to put a star on the screen. I also did a course on Visual basic, but it was more gimmicks that Application development. But it was truly in the year 2007 when I started my Master in Computer Applications that I found a new flare for developing applications. 
I was very late to computers in general and even when I joined my Masters, computers were not really accessible to me. But when I joined my Masters where one is actually expected to hone the skills which they already have, but in case it was were I was learning the skills, initially it was very difficult. I was not sure what computers had for me nor I had a natural flair for programming. But the thing about computers that attracted me was the visual medium it gave. Initially it was just a door t…
Read more