Photo Organizer

view_random_photo

create view view_random_photo as
  select small_image_path, medium_image_path, large_image_path
    from photo
   where photo.identifier=(select cast(random()*count_photos() as integer));

• photo

Version 2.5

Still in use

= Version 2.5 =

create view view_random_photo as
  select small_image_path, medium_image_path, large_image_path
    from photo
   where photo.identifier=(select cast(random()*count_photos() as integer));