Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: is there any random function????

    is there any random function in postgreSQL???? i need to generate strings for columne id - varchar2(11) and specify that it must by stg like '******/***' star is a number......is it somehow possible?????

  2. #2
    Join Date
    Mar 2004
    Posts
    110
    What you could do is setup two colums, use sequence to automaticly increase the id numbers.

    And when selecting the row one could concatenate both rows wich would result in a string '$colum1' . '/' . '$column2' (in for example php)

    -Ed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •